Help with Forms!

  • Thread starter Thread starter Beth
  • Start date Start date
B

Beth

I would like to know how to insert a log number in every
record of an Access form that I have created.

Each log number would sequentially increase by 1 for each
record. For example, record 1 would be ABC0001, record 2
would be ABC0002, record 3 would be ABC0003, etc.

Can anyone help?
 
Using the pattern you have given, set the default value of the control that
shows the log number to

="ABC" & Format(DMax("CLng(Right([FieldName],4))", "[TableName]") + 1,
"0000")
 
ps,

Will this be a multi-user database? If so, this will need to be moved from
the default value.
 
Back
Top