I have set up a form for user log-in with options to view sales figures etc form two combo boxes (area & job title)
Now I need to know how to validate user name and PID, and after the user has chosen the required fields the form goes to another relevant form listing all the details.
Do I need to use code or can I do this using a query.
I am realy struggling !

Use dlookup to determine if its a valid user and pid, if dlookup = 0, then the user and pid are not valid; deny access.

This assumes that you have a table of user and passwords and are not using Access Security.