Populating a field with a number + 1

[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

 

[fredg]

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

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