Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You were right on target DAve, Thanks so much.. I had originally used a
choose formula to randomly populate my data table with sample data. Then I pasted specialvalues, leaving the formula in teh very last row( In case I needed to recreate that later) You prompted my memory-- as soon as I moved those formulas to a non-copntigous area the data entry form worked great. Thanks for jogging my memory! "Dave Peterson" wrote: Are the first 3 fields formulas? Is the worksheet protected with the first 3 columns having the cells locked and the column having its cells unlocked? JR Hester wrote: Excel XP on Windows XP Excel database with only 4 fields( Name, date, type, notes). The data form displays all 4 fields and values in browse mode. When NEW buitton is selected to enter a new record, only the last field NOTES allows data entry. I should expand here a bit; the first three fields do not display the value box in NEW mode. There must be something controlling this that I can't locate. I tried adding a couple of new fields and those show up and allow data entry. Accepting any and all ideas suggestions, and thanks in advance! -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Form for data entry | Excel Discussion (Misc queries) | |||
Data Entry Form | Excel Discussion (Misc queries) | |||
Can I use a FORM to enter data if I have more than the 32 fields? | Excel Discussion (Misc queries) | |||
Data Entry Form | Excel Worksheet Functions | |||
data entry form | Excel Discussion (Misc queries) |