Form pre-population help

[tmcrouse]

I have a database that has a table that houses the userID, userlast, userfirst, machine, managerlast, managerfirst. I have a form that is built with the labels that are appropriate. Then list boxes for the information to be displayed. At present when the database is opened, the form is automatically not in design view. It is set for a user to input their userID. What I want is when they input their UserID, the rest of the fields will populate based on their userID entered. I am not sure if I use an event for onclick or should build an onclick VBA code in the Access forum or create some sort of iif statement and build a query or what. I just want the simpliest way to accomplish the prepopulation when they enter their userID.

[NTC]

the most common way is to have a start screen/form that includes mandatory login. this form stays open. this provides an object that holds the login info

those forms/reports are all sourced on queries - and all those queries have criteria which is from that login......so that when they run, they are filtering for records that conform to that login....

of course all this presumes you designed the tables with this in mind upfront....but it is very common. For instance as a salesperson enters data - their login ID is also entered into a field in the record. Then when they login - the query filters on that ID so that they only see records that have their ID.

If you have multiple people to see the same data then design it for "class" of user ID.

This is the broad concept - actual implementation technique varies widely by requirement.

[tmcrouse]

Do you know of any code examples. My boss built this database and all she did was put the tables in. I have not used form builder in Access for over 4yrs and you know what they say, you don't use it you lose it. She wants my help and I am like God I have 500 other things going on and already working 12 hour days plus going to college. This is her project not mine but she never did forms in Access in school and knows I did but again it was 4 years ago. I have all my past textbooks out but don't know where to even begin cuz it has been so long. She wants this by next week and I fear I am going to have to tell her to figure it out herself unless she wants to do all my projects and switch. Which she will never do. She always throws her work on me and it kind of drives me nuts. I can't do everything.

[NTC]

Well making user level security isn't a trivial task. The particulars of any actual implementation are beyond the scope of a forum. Experience counts. Access isn't really a trivial product - it is a full database. I think because it often is perceived as 'free' inside the Office suite it is misunderstood by the lay population. Good luck managing your boss!

[tmcrouse]

I had to go through many tutorials online to finally find the answer to the pre-populating. I finally got it to do what I want. But now my add record is messed up. So I will now post this new issue. I used the add record wizard in Access 2000 to add what is on the form from the combobox and textboxes to the new table and it doesn't add anything. Argh. But at least the prefill finally works. 1 more item and then I am done. Did my exit and refresh stuff and the skill stuff prepopulates how I want. Thanks to all for the assistance.