Hi guys
Could anybody help. I need a code to update my tables. Basicaly I have 2 forms.
1 table with Name, Surname, DOB etc.
2 table with Date, TimeIn and TimeOut.
1 query with all details
I have Dlookup code which finds out the ID
DLookup("[ID]", "[Table1]", "[FirstName] ='" & Forms![Form1]![FirstName] & "' AND [Surname] ='" & Forms![Form1]![Surname] & "' AND [DoB] ='" & Forms![Form1]![DOB] & "' ")
I have text box with "TimeOut" which needed to be update right record.
Does this make sense.
Thanks very much
Could anybody help. I need a code to update my tables. Basicaly I have 2 forms.
1 table with Name, Surname, DOB etc.
2 table with Date, TimeIn and TimeOut.
1 query with all details
I have Dlookup code which finds out the ID
DLookup("[ID]", "[Table1]", "[FirstName] ='" & Forms![Form1]![FirstName] & "' AND [Surname] ='" & Forms![Form1]![Surname] & "' AND [DoB] ='" & Forms![Form1]![DOB] & "' ")
I have text box with "TimeOut" which needed to be update right record.
Does this make sense.
Thanks very much