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.