Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding A Button To Insert Date In A Form

Status
Not open for further replies.

jambo1977

MIS
Aug 7, 2001
1
GB
I'm quite new to VBA, any ideas how you can have a button that you press which will then populate a field with the current date?
 
ok if you have the field called date

then under the on click property of the button

add

me![Date] = now()

that will add in todays date or replace now with any date you want to add
 
Why not just default the field with todays date on form load and then let the user change it if they want. Saves them from having to do a keystroke... Terry M. Hoey
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top