GW McLintock
New member
- Local time
- Today, 12:12
- Joined
- Oct 14, 2014
- Messages
- 7
I am somewhat experienced in Access -- I know all of the main features and can even do a bit with macros and VBA, but I'm by no means an expert. I need help creating a button to auto-fill a field in all the records in a table.
I have a database centered around a table called tblCand; each record contains a date field called intDate. On the main form, initDash, when the user hits a certain button, a window pops up (either a message box or perhaps a separate form) that asks the user to type in a date, which would be stored as intDateDB. When the user hits OK, I want the value of intDateDB to replace the value of intDate in all the records in tblCand.
I'm not sure whether this is called auto-filling or auto-populating, but hopefully someone understands what I'm trying to do and can help me out.
Thank you!
-J.
I have a database centered around a table called tblCand; each record contains a date field called intDate. On the main form, initDash, when the user hits a certain button, a window pops up (either a message box or perhaps a separate form) that asks the user to type in a date, which would be stored as intDateDB. When the user hits OK, I want the value of intDateDB to replace the value of intDate in all the records in tblCand.
I'm not sure whether this is called auto-filling or auto-populating, but hopefully someone understands what I'm trying to do and can help me out.
Thank you!

-J.