Find/Display Next Available Number

[jabrjo]

I am fairly new to Access so I apologize if my questions or responses are a little confusing.



Anyway - I am creating a form for users to enter data. Each entry needs to have a "Event ID" associated with it and these Event IDs may be used more than once but will refer to the same Event (if it was a single entry with no duplicates, I would just use the rows primary key). Does anyone know how to create a query that looks at a list of existing numbers (Events already in the table) and returns the next/an unused number? I would like to create a button that says "Next available Event ID" and provides the user with a number.

Thank you for your help!

[ranman256]

On the form, calc the next id:

txtEventID = Dmax("[EventID]","tMyTable") + 1

[jabrjo]

Thanks, Ranman. Where do I enter this calculation? Do I create a query or can I calculate this via a button?

[jabrjo]

Ranman, I built the expression in a query and will create a button to display the number. Thanks!

[June7]

Query is not needed. Domain aggregate functions can be used in VBA or in textbox ControlSource and DefaultValue properties.