I have successfully created a query, the outcome of the query is to create a unique id in the database, and am able to run it as an embedded macro.
The outcome of the query is each row appears as ‘ID 1’, ‘ID 2’ etc.
What I am trying to do is have the results of the query appear in the ID field of the form, instead of in a new table where i have to then copy and paste the results across.
In my current query, the field reads ScammerID: “ID” & “-” & [TableID]
(I want the ‘output’ to be ID – 0001
I have tried changing the query to an append query, but it comes up with a syntax error.
I have also tried an update query, also with a syntax error.
Illyes Tzigane is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.