creating a form with a password

[Myvee]

Hello - this is my first post and it is going to be a long one! I have been creating a database to perform product inspections for work. So far everything is working very well. The auditor enters the information he/she is prompted for during the inspection. Once completed, here is what I would like to have happen, but it doesn't work as I hoped; they click a button called- "provide disposition and sign-off". The button opens a small dialog box where they can select either accept or reject from a list box. (I should also mention that the form opens and is linked by transaction number to the data collection form we just came from. The table that contains all this data is calle the general ir transaction table).
That is all very well. Now here comes my problem. On this small dialog box I would like to put another button called "Auditor Sign-Off". When pressed the user should be prompted for their password. If correct the password will return the auditor's name in a text box on the form. I tried using a parameter query method - but it locks the form. Also, in the general ir transaction I cannot get the name returned to copy into the field which would indicate what auditor performed the inspection. I hope this isn't too confusing. Aaaagh! Can anyone help me? Thank you!

 

[ItIsHardToProgram]

What you want to do is to do a table where u have usernames and password, and then load a form on click, on that form you have the list of names + password, or only a password entry, and with the dlookup fonction you go grab the name in the table.... (vbase editing)

Hope this helps. to copy a field from form to form when they are both opened, use the me.parent.form[Enter object name] = me.[enterobject name]

I think this is what your looking for...

 

[ItIsHardToProgram]

If this dosnt help, go to thread707-1201105.

 

[Myvee]

Hi - thanks for responding so quickly - but I'm afraid it's not quite what i need to do here - i already have code for what you are describing. What I need to do is kind of like a signature authentication. When the person clicks the button, they are prompted for their password and if correct it returns their name. (I can do this part through a parameter query by form). The problem is, that I would like to take that name returned from the query and somehow get it into my main table in the "auditor" field. I tried your suggestion to copy the returned name from the query to the auditor field in my main table but it didn't work. It either came up "Name?" or blank.