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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Static Date in Data Entry Form

Status
Not open for further replies.

dzdncnfsd

MIS
Jul 14, 2000
118
0
0
US
I have a form that asks for several pieces of information, date being one. How do I make the date repeat in all records that are added while the form is open? The current date will almost never be used, so I can't just do a = date() function.
Thanks,
Gladys
Gladys Clemmer
gladys.clemmer@goldkist.com

 
You can write something like that and call them on Enter or On focus event of relevant controls

Dim StrDateVal as Date

If Me.RecordNew = True Then
StrDateVal = Me.DateField1
Me.ActiveControl = StrDateVal
End If

Cheers!
Aqif
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top