Question Local Defaults for user

[jwillet1]

I have a database that will be in use and to simplify user entry i am hoping to get some help in storing some default values for each user. Each user has a local copy of the front end of the database while the back end is stored in a network location.

As part of the input process each user has to enter their userID, project, and department. As that will be relatively stable every time they make a log, I am wanting to have the user setup up some defaults that are already filled in when they open the logging form. What I would like to do, is the first time the database is opened it will check for default values, if there are none then it will open the defaults form and the user can enter their information. I see some sort of check on open but i don't know the best way to store these values to use every time that users copy is opened.

 

[jwillet1]

That part i have got to work, however I would like to store those values, so the next time the user opens his/her copy of the database it has the values entered previously. I have been able to get the defaults to work in a single session. However i would like to store them in a way that allows them to be saved to use next session.

After some more research it seems like i want to store these values in a local table after the user inputs them the first time. However I guess, and i may be over thinking this, what i cant figure out is how to use these table stored values as defaults for combo boxes on my logging form.

 

[jwillet1]

I figured out a way to do it. I have added a local table that stores the default information and a user input form that does not allow addition to the tables, only edits. This will hold the defaults and i am using a DlookUp to pull those values and use them in the new record input form.