icemonster
Registered User.
- Local time
- Today, 09:51
- Joined
- Jan 30, 2010
- Messages
- 502
Code:
Set rs = CurrentDb.OpenRecordset("qry_employee")
rs.AddNew
rs.Fields("EMP_LASTNAME").Value = Me.txtLastName
rs.Fields("EMP_FIRSTNAME").Value = Me.txtFirstName
rs.Update
rs.Bookmark = rs.LastModified
lngPatientID1 = rs!ID_EMPLOYEE
rs.Close
Set rs = Nothing
lngPatientID2 = lngPatientID1
Set rs = CurrentDb.OpenRecordset("
anyone know or could tell me how to convert this using an entire table instead? cause i need to query each primary key entered.