Autonumber on form

[lalee5]

I would like to have an auto number on the form so every time the form is load this number increases.

I already have an auto number for each record I added.


The number on the form needs to increment only when the form loads, diffrent than the auto number for record.

Please show how you would go about doing this.


Kay

 

[jsaliers]

I don't know if this is the best way, but set up a table (Ref_Count). Add an autonumber field, and a misc field. In the form OnOpen() event, add a new record to Ref_Count table, and put something in the misc field. Therefore, every time the form is loaded, a new record is added to Ref_Count, and the highest autonumber is the count of number of times that the form was opened.

Hope this helps you.

Jon

 

[lalee5]

How do I link my current form to this form? I need to have this number on the current form too.


When I am in the ccurrent form I am adding 3 to 4 records to the table.


The auto number I am adding to the form will kind of like an invoice number for all the records I added.