Help with Forms

  • Thread starter Thread starter Tina
  • Start date Start date
T

Tina

I have a form that has Customer information on it. There
is a subform that brings up specific information on each
item related to the customer. When I click add new
record, I would like the next ID number available under
that customer to automatically appear in the ID control on
the subform. How would I go about this?
 
Do you mean that you have an ID field in a table and you want the highest
number so far plus one?

Use DMax + 1 to find the next number. You'll find help on DMax in Access
Help but write back if it doesn't make sense.
Evi
 
I printed off the info from help, but I am confused as to
how I do DMax +1 or where I'd exactly put the code. Since
I have to wait for the Customer Id to be entered, I'm
assuming I would put the DMax code in the After Update.
Is that correct?

Once I type in the Customer Id, I want the next available
System Id to be filled in on the form so it can be added.
So it would be whatever the last record for that customer
plus 1.
 
Back
Top