Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Updating with ADO and determining record ID before closing recordset.

Status
Not open for further replies.
dbero

dbero

Technical User
Mar 31, 2005
109
0
0
US
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!
 
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
174
TheresAlwaysAWay
TheresAlwaysAWay
atadbitslow
  • Locked
  • Question
comparing fields, one populated with data and one blank 2
Replies
8
Views
139
atadbitslow
atadbitslow
MikeRei
  • Locked
  • Question
Help taking horizontal data and displaying it vertically (continuously)
2
Replies
27
Views
339
dhookom
dhookom
swicor
  • Locked
  • Question
Exact match using access upper and lower case
Replies
0
Views
114
swicor
swicor
lameid
  • Locked
  • Question
Office / Access 365 Trusted locations and GP
Replies
0
Views
108
lameid
lameid

Part and Inventory Search

Sponsor

Back
Top