Dmax Question

[milte]

Hello everyone,

Although an easy question for all, I still need assistance.

I have a text box which increments +1 when a new record is added. I have it placed on the control of the text box, but would like to have it automatically run when the form is opened. The code in the control is:

Me.Auto_Num.Text = DMax("Auto_Num", "tblMaster") + 1

Thanks for your help.
Milt

 

[TheAceMan1]

How are ya milte . . .

Transfer your code to the [blue]On Current[/blue] event of the form!

See Ya! . . . . . .