C
Chey
I have this code already and it works great. I would like to add something
to it.
Private Sub Command29_Click()
Dim TANo As Variant
TANo = Me.[TA Numbers].Form![TA Number]
Forms![Travel Request 0 Layover]![Travel Request.TA Number] = TANo
DoCmd.Close
Forms![Travel Request 0 Layover].Requery
DoCmd.GoToRecord , , acLast
Forms![Travel Request 0 Layover].FilterOn = True
I have a field trip cancelled. If this field is not null then When they
return to request page I would like it to go to that record. This is so the
traveler can update there request. As of now when the return to request page
it creates a new record. I also have it no dups. Thanks
Chey
to it.
Private Sub Command29_Click()
Dim TANo As Variant
TANo = Me.[TA Numbers].Form![TA Number]
Forms![Travel Request 0 Layover]![Travel Request.TA Number] = TANo
DoCmd.Close
Forms![Travel Request 0 Layover].Requery
DoCmd.GoToRecord , , acLast
Forms![Travel Request 0 Layover].FilterOn = True
I have a field trip cancelled. If this field is not null then When they
return to request page I would like it to go to that record. This is so the
traveler can update there request. As of now when the return to request page
it creates a new record. I also have it no dups. Thanks
Chey