User initials...

[Frankenoid]

OK, I'm sure there is a simple answer to this, but I don't know it.

What I need is a simple way to have a user enter their initials on a form 1 time, and have the value stored in an unbound hidden text box on the form.

The form pulls up a list of archive boxes which are currently at our lawfirm. To indicate a box is to be sent back to storage, a box is checked. The master table is updated to reflect that the box is no longer at our firm AND... info is written to a history table to note the box #, the date, where the box was sent (to archives -- a separate form will do the same for pulling boxes back from archives) and the user who accomplished the deed. That way, when a box is lost I will have a record of who did what to it.

So, how do I get something to pop up upon opening the form, ask for the user initials, place it in an unbound text box, and then go away? I've tried using a simple form, but I can't get it to go away after the initials are typed into it.

Thanks for helping this novice -- Franki

 

[scottfarcus]

In the OnOpen event of the form, enter the following code:

Me.txtHiddenTextBox = InputBox("Please enter your initials:", "Initials")

 

[Frankenoid]

See, I knew it was simple. I'm sure I'll come up with another basic question (I will NOT call it a stupid question -- stupid is the Access "help" function which couldn't manage to lead me to this simple answer)....

Thank you kindly