Populating a field with a number + 1

  • Thread starter Thread starter David Brown
  • Start date Start date
D

David Brown

I am trying to populate a field (a Quotation Number) that
would be one higher than the last quotation number.

I cannot use Autonumber because the table already exists,
and I need to change the numbers each year.

How do I have the Form lookup the highest number and
increase it by one?

Thanks,

David
 
I am trying to populate a field (a Quotation Number) that
would be one higher than the last quotation number.

I cannot use Autonumber because the table already exists,
and I need to change the numbers each year.

How do I have the Form lookup the highest number and
increase it by one?

Thanks,

David
Click to expand...

In the Control on the Form, set the control's default value to:
=DMax("[QuotationNumber]","Tablename") + 1
 
Back
Top