Store a value temporarily and use it as a default value?

[Guest]

Is it possible to capture a value temporarily with a form, and use it as a
default value in field in another form.

I want users to choose their names with a drop down menu when they open the
database and after choosing their name and pressing a button on the form it
takes them to a form wich they fill out,. One of these fields is for the name
of the person who is filling out the record but I dont want them to choose it
every single time they enter a record so I want to capture it and re-use it
as long as they keep the database open. I dont know if im projecting my idea
correctly or is there an easier way of doing this.

Thanks

 

[Lynn Trapp]

Why not just capture the user's network logon name instead?

http://www.mvps.org/access/api/api0008.htm

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Guest]

That specific workstation is logged on every morning and stays on until we
close and it is automatically restarted at night. Users dont log off and on
during the day.

Thanks.

 

[Lynn Trapp]

Ah, ok. You could also implement user level security and have them log on to
access with a user name and password. then you could just use the
CurrentUser function to get that name. Otherwise, you can reference the
value of a combobox on a form with the following syntax:

Forms!YourFormName!YourComboBoxName

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Jeff Conrad]

in message:

That specific workstation is logged on every morning and stays on until we
close and it is automatically restarted at night. Users don't log off and on
during the day.

As Lynn has already mentioned, a good possibility is to implement Access
User Level Security (ULS) so you can force people to log in and then use the
CurrentUser function to return their User ID. ULS, however, is a difficult
concept to grasp and takes time to "get right." If you wish to pursue this option,
read all of the information I have accumulated here and practice on dummy
databases until you really get it down right:

http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#Security

As another option, there is a sample download file available here which has a
fully functioning log in system for study:

http://members.shaw.ca/glenk/access2000.html
(Look for Security & Log On Demo Database For Access2000 (Richard Rensel)

Good luck with your project,