DougAtAvalon
Programmer
with the following code I usually can use a dlast method to get the AutoID number assigned. I'm having a problem any ideas on how to retreive that number?
-------------------------------
Set dbs = CurrentDb
Set rcrdset = dbs.OpenRecordset("Candidates"
rcrdset.AddNew
rcrdset![DateOfEntry] = Format(Now(), "mm/dd/yy"
rcrdset!ID = Forms![Organizations].[Placements Subform].Form.ID
rcrdset!ContactID = vContactID
rcrdset!ResumeSent = vResumeSentFromPopUp
rcrdset.Update
rcrdset.Close
Set dbs = Nothing
Set rcrdset = Nothing
---------------------------------
thanx,
Doug
-------------------------------
Set dbs = CurrentDb
Set rcrdset = dbs.OpenRecordset("Candidates"
rcrdset.AddNew
rcrdset![DateOfEntry] = Format(Now(), "mm/dd/yy"
rcrdset!ID = Forms![Organizations].[Placements Subform].Form.ID
rcrdset!ContactID = vContactID
rcrdset!ResumeSent = vResumeSentFromPopUp
rcrdset.Update
rcrdset.Close
Set dbs = Nothing
Set rcrdset = Nothing
---------------------------------
thanx,
Doug