signing on to a form

[susan]

I have a data collection form I would like to have the
person entering the data give me their initials. But I
don't want to require them have to enter them for each
record entered. How do I have them enter their initials
when starting a data entry session, then have access copy
the initials to each record they enter till the session is
ended. Not requesting the id till the next data entry
session is begun.
I do not want the request for the initials to display if
the person opening the form is just viewing previously
entered information.
suggestions?

 

[tina]

well, in a nutshell (kind of)...
create a form and set it to open when the database opens
(Tools, Startup).
put an unbound textbox on the form for the user to enter
his/her initials.
put two command buttons on the form, one for Add/Update
and one for Review. set the Review button's macro action
OpenForm property Data Mode to Read Only. set the
Add/Update button's...Data Mode to Edit. add a condition
to the Add/Update button's macro, as

Condition Action
Textbox Is Not Null OpenForm
Textbox Is Null MsgBox (Message: Enter your
initials.)

if you leave the startup form open (perhaps as Visible =
False) while the data entry form is open, you should be
able to set the Default Value of the initials control - on
the data entry form - to Forms!StartupFormName!Textbox

hth

 

[Mike Mueller]

: I have a data collection form I would like to have the
: person entering the data give me their initials. But I
: don't want to require them have to enter them for each
: record entered. How do I have them enter their initials
: when starting a data entry session, then have access copy
: the initials to each record they enter till the session is
: ended. Not requesting the id till the next data entry
: session is begun.
: I do not want the request for the initials to display if
: the person opening the form is just viewing previously
: entered information.
: suggestions?

Another option which presents itself is to pull their
network login information and autopopulate a field. There
was a discussion on this on August 1 with the subject of
'Get Network Username'.

HTH-
Mike