Hi
I am used to using the following sub for a variety of reasons but i would like to try and take it to the next level to assist the access databases and querys.
when this code sends the record to the database the database generates a unique key. i would like to capture this key within vb so i can then reference this record in another table.
for example the following updates my OUT table with a new record. i would like this recordID as an update query field within my master table.
there is multiple people submitting using this code to the out table so i cannot just use another sql to get the maxSubmittedDate to get the recordID.
a future question will be ensuring i don't get 2 records submitted at the same time thus only 1 record gets recorded within the DB
i am rubbish at explaining what i want!
kind regards
Rob
Bookmarks