Forms

[Tina]

I have a form that has Customer information on it.
Therebeen suggested but I don't know how to make DMax +1 work?
If I should use this, what would my code looks like???

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.

 

[Ken Smith]

In all probably, the form and the related records are
linked by the customer ID field, which means the customer
table (custtbl) would have a unique ID number for each
record and the associated records in another table
(itemstbl) might also use that number in addition to a
unique recordid number to make the subform work.

In all probability all you need to do is to open the
subform design and include that record id on the form,
which may require you to add that to the underlying
dataset. If you have to do the last, open the subform in
design mode, click on the square in the upper left, go to
and open the data source (if it is a query or SQL
statement) and put the recordid in the dataset.

Once you have done this, when you start to add a new item
for the customer, the next record id will automatically
display.

Hope this helps.

 

[Tina]

Thanks for the information. I'm just a little confused.
Where do I get the recordid and which dataset do I enter
it? What would it look like??

Thanks for any additional information that can be
offered...