use a button to enter a value into a table

[campbell707]

code works great...please ignore attached file (doesn't have correct code)

[campbell707]

I actually got the code to work...still not sure how you changed the background color though when the letter is filled in the box.

Thanks a ton for the code!

[vicsaccess]

Test database.zip
ok, still feel like playing. as for the color change its the same as with excel. from the design view go to the format tab and you will see the conditional formatting the same as excel's. as a little fun take a look at the new form "form1". this will give you an ideal of a different way for your users to do it all on one page rather than jumping around or trying to use the record buttons at the bottom. as you select the bottom record it loads on the top for editing. also, and June7 will laugh at me for this, watch your field names and the spaces between them. spaces create more problems than they are worth, its easy to rename a field in the captions for the user to see but putting spaces in field names isn't worth it. enjoy

[ssanfu]

Shouldn't display an autonumber field on a form

"Date" and "Time" are reserved words and intrinsic functions/commands and shouldn't be used for object names.