text box trouble

[akshayjoshi222]

i have form in which there is a text box.Users put the password in the text box.
Problem is,text box remembers the last value entered by any user.So,if a new user opens the form he can open record of the last person logged.i want text box to be empty every time the form opens.
wht should i do

 

[vbaInet]

I don't understand how your textbox remembers what was entered before and displays it? Check the Access Options to see if there's something you can untick to prevent this.

Use something like this on the ON LOAD event of your FORM:

txtBox1.Value = ""

 

[statsman]

Set the default value of User to blank. In the properties, set the default value to " " (quote followed by blank space followed by quote).

Once the password had been entered and read, the form should be closed. Each time it is re-opened, the User field should be blank.

 

[akshayjoshi222]

thnks man,u r awesome,u r helping so much,saving my job,thnk u vry much

 

[vbaInet]

You're welcome. Glad to have had some input.

 

[missinglinq]

If the form is truly closed between users, and the textbox retains the last password entered, then the textbox has to be bound to a field in a table.

If the textbox is unbound, then the form is not being closed between users. Switching between Form View and Design View is not the same as closing the form, and an unbound control will exhibit this behavior under this condition.

What really concerns me here is the possibility that you have a multi-user database and do not have the app split into a front end/back end.