Label Caption

[Sharoon]

I made a label in a form to diplay the last account number added
so the user can know where to start again
I added this code
before add new record command
LastAdded.Caption =Me.AccountN.Value

Here is the problem:
when I close the form and I get back I see the label's caption blank??

any idea how to solve this problem??

 

[Jack Cowley]

I am not sure where you are triggering the code, but this should work...

LastAdded.Caption = DMax("[AccountN]", "TableNameHere")

hth,
Jack