I have 3 text boxes; start date, end date and alternate end date. Start & end are bound to table fields. alternate is unbound
the tab order is start, alternate end and end dates
the start date is enterered with a date picker and presently i'm using the got focus event of end date to populate the end date box with this code:
If IsNull(Alt_date) Then
Me.end_date = "31/08/" & Year(Now) + 1
Else
Me.end_date = Alt_end_date
End If
The code allows an alternate end date to be left blank or entered. if there is no entry, the default date from the code is used.
by using the got focus event, the user has to click on the end box to get it to populate.
can it be populated just by tabbing to it from the alt end date box? Or even by tabbing on to the next box
I'm sure it's simple, I've just lost the plot!!
any help welcome