Password protecting a given box

[DDrowe]

Is there a way to create a box on a form that the user must first enter a
password before filling out?

Would I need to use the security feature for the whole database? I know its
not great but its good enough for this application. With the person signed
in, can I make it so that he has to enter his / her password again before
entering their name into the signature box? Or is there another way to track
it so that I know who entered the name into the signature box?

Thanks

 

[BruceM]

One possibility may be to use the API here to get the network login name:
http://www.mvps.org/access/api/api0008.htm

The web site says to paste the code into a new module, which you could do,
but you could paste it into an existing standard module, if you have one, or
the form's code module if the code would only be needed there. To get to
the form's code module, open the form in design view, then click the code
icon on the toolbar or click View >> Code.

To create a standard module you could create a module at the database window
(the box with tabs for tables, queries, forms, etc. that opens when you open
an Access database that does not have the option disabled in the Startup
options, or that appears (unless blocked) when you open the database and
press the F11 key).

Then in the signature box After Update event:

Me.SignedBy = fOSUserName()

SignedBy is a text field in the form's recordsource table.