New Record, text box appear 1

[SpeedStick]

I would like to have a text box appear each time a new record is added.

I have form which is used to maintain the staff login page. We only want the password field to be visible only when a new employee is added. Below is the code I have been working on. I am really looking for the value to put in where NewRecord to make this simple function work.

If Me!UserName = NewRecord Then
Me!Password.Visible = True
Else
Me!Password.Visible = False
End If

 

[RoyVidar]

Try:

[tt]if me.newrecord then[/tt]

You could probably use only:

[tt]Me!Password.Visible = Me.NewRecord[/tt]

too, I guess. Probably in the on current event of the form?

Roy-Vidar

 

[PHV]

In the Current event procedure of the form:
Me!Password.Visible = Me.NewRecord

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SpeedStick]

Roy,

Thank you for your quick response. Actually the second recommendation was great and I used that for my task.. Thanks again for your help.

Scott