Sturmtruppe
Registered User.
- Local time
- Today, 10:49
- Joined
- Mar 26, 2009
- Messages
- 18
I want my date & time fields in my subform to automatically input values after i click a check box on my main form.
The values i want it to input would be the data from the date & time fields in the previous record. Is there an AfterUpdate event i can use on the "Called Back?" check box that would update "Interview Time" & "Interview Date" with previous info?
Thanks
Darren
**EDIT**
I found a way to get the default value to show the previous records, the one for interview time:
=DLookUp("[Interview Time]","IAG_Interview_Date","[Int Number] = " & DMax("[Int Number]","IAG_Interview_Date"))
but for this, is there any way to let it add 30 minutes each time, so the 'interview time' = the previous interview time + 30 minutes. I'm guessing this is too basic to allow me to do that.
The values i want it to input would be the data from the date & time fields in the previous record. Is there an AfterUpdate event i can use on the "Called Back?" check box that would update "Interview Time" & "Interview Date" with previous info?
Thanks
Darren
**EDIT**
I found a way to get the default value to show the previous records, the one for interview time:
=DLookUp("[Interview Time]","IAG_Interview_Date","[Int Number] = " & DMax("[Int Number]","IAG_Interview_Date"))
but for this, is there any way to let it add 30 minutes each time, so the 'interview time' = the previous interview time + 30 minutes. I'm guessing this is too basic to allow me to do that.
Last edited: