Help with Forms!

[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?

 

[Wayne Morgan]

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")

 

[Wayne Morgan]

ps,

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