Use a Query to generate auto ID

[banpreet]

Hi Guys,



I would like to create a button that will run a query based on what user chooses on a form that will automatically create a unique Id for them. I don't know if I should use vba or if its simply easier to use a query. I have a table with these fields [Requestor_LName] [RequestorFirstName] [Requestor_Clock_Number] [Date] [Model] and [GTSR_ID]. I have put these all on a form and want the GTSR_ID field linked to a button that will run the query. GTSR_Id is the primary key and the [Model] field is a combo box with bunch of the options the user chooses. I want to ID format to be generated "GT-(the model the user chooses)-16(the year)-001". After 001, the button will increment 001 to 002 to 003 and so on. How can I do this with simply create a query?

Thanks, all help is appreciated.

[ranman256]

let the table generate the autoID, also create YOUR ID. (i think youre putting too much effort into an ID where the table can do it for you)
You cant create multiple id via a query. It cant generate 1,2,3, etc via query.
It CAN do this 1 record at a time. It can calculate 1,2,3 if appending 1 record.
I would use
"GT-(the model the user chooses)-16(the year)-" & AUTOID

Like I said, more work than you need to get an ID.

[banpreet]

I could let the table generate ID, but we want to user to autogenerate the id on the form on its own instead of assigning them from the table, so then they can fill the forms after that. Where would I put "GT-(the model the user chooses)-16(the year)-" & AUTOID in? And how do I make sure the model will be linked to the combo box depending on what model the user chooses? Thanks!