Hi, I have a continuous form. Im wandering if there is some way of not showing the last record whilst still allowing additions? ie I am wanting to have an 'Add' button that will insert a new record and automatically populate the date and time fields with the current values. The following code works fine on allowing additions, but once the fields have been populated it no longer even shows a new record, and subsequent presses of the button adds a new records but its all warped and does not show in the normal continuous way.
DoCmd.GoToRecord , , acNewRec
If IsNull(t_date) Then
t_date = Date
t_time = Time
End If
Me.ctlt_Type.SetFocus
DoCmd.GoToRecord , , acNewRec
If IsNull(t_date) Then
t_date = Date
t_time = Time
End If
Me.ctlt_Type.SetFocus