Can i add a query to a form already set up or do i .......

[cev2010]

In Access 2003:



I have set up a query to work out the next number for the customer ID field based on the max no already in the table. I have then set up an add new customer form and want the customer id to automatically appear as the updated field from the query

I'm guessing i may not be able to do that, so i have built an event on the customer ID field in the form that reads

=DMax(“[Customer ID]”,”tblCustomer”)+1


But that does seem to work either - i basically need a form that generates a new customer id based on the max, but i cant have it set as an autonumber field


Any suggestions?
Thanks

[John_G]

Hi -

Why do you say the Dmax function call is incorrect? How are you using the expression, and do you get an error message?

Try setting the Customer_ID on the form using the On Current event, but only when the record is new:

if me.newrecord then me![Customer ID] = DMax(“[Customer ID]”,”tblCustomer”)+1

John