Calculations in textboxes are not saved to fields without code.
You only want a date saved if Bay# is entered?
BTW, should avoid use of spaces and special characters and punctuation (underscore is exception) in names. Better would be BayNum, TimeIn or Bay_Num, Time_In.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Yes, When I enter the number in the Bay # box on the form I want TIME IN box to show NOW()
Also I took your advice and changed Bay # to Bay_Num and TIME IN to TIME_IN
I only use VBA. In the AfterUpdate event of Bay_Num control, select [Event Procedure]. Double click the ellipses (...) and this will take you to the procedure in VBA editor. Type code, like:
If Not IsNull(Me.Bay_Num) Then
Me.Time_In = Now()
Else
Me.Time_In = Null
End If
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Success,...Thank you for the code that was the first time I have Entered data straight into the VBA screen