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

T

ThePro

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
 
T

ThePro

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.
 
L

Lynn Trapp

J

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.
Click to expand...

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,
 
Top