Hello:
I am using the basic code below to load data from a non-bound form.
LoadErrorData.Open "TblDemographics", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
LoadErrorData.AddNew
LoadErrorData!FamilyName = Family
...
LoadErrorData.Update
LoadErrorData.Close
I now want the the ID for the record just added so i can use it to add a related record. is there anyway to get the ID for this newly added record w/o opening a new recordset? Thank you!
I am using the basic code below to load data from a non-bound form.
LoadErrorData.Open "TblDemographics", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
LoadErrorData.AddNew
LoadErrorData!FamilyName = Family
...
LoadErrorData.Update
LoadErrorData.Close
I now want the the ID for the record just added so i can use it to add a related record. is there anyway to get the ID for this newly added record w/o opening a new recordset? Thank you!