How can I increment values of records on a form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with information on documents. Each document goes through
several review steps. Another field contains a document number. I want to
assign this sequential tracking number to each document only when the
document gets to review step 3, for example.

We track the progress of the document on a form. I know I can use the
setvalue action in a macro to change the value in the tracking number field,
but how can I find the highest value in this field and assign the record the
highest number + 1?

Thanks!
 
Your Update Status form could have a button to run an apend query that adds a
record to the status table. The form could have a textbox showing Last
Review Number and the append query have a column/field like --
New Review Number: [Forms]![Your Update Status form]![Last Review Number]+1
 
Back
Top