Hi everyone,

Im in desperate need of some help here. My boss has got me setting up an access database. I have built all the tables, forms, macros etc and works fine. However, it is going to house the other team members details. THere are several forms which each employee will need to fill in / maintain.

I need a way of having an initial login screen wherebye, when they type in the personal ID (which is a field in most of the tables) then only information about themsleves is displayed and available for edit.

Ive looked through your threads and found similar queries, but nothing i can use. If you can help in any way, you may just save someones job! Please dont say the answer is vbcode cos ive never used that before.

Thanks so much for your help.

I done something similar:

This is the line that i would put in my query so that it only selectes records with the matching "Personal ID"

[Forms]![frm_MainControl]![Personal ID]


I had a table "tbl_MainControl" with a field "Personal ID"

and a form "frm_MainControl" that used "tbl_MainControl" as a record source

The query will need the form to be open so that it can work.

Hope this makes some sense.

I suggest searching the forums for "security". Many threads, much good information available.

cheers for your help there guys, hopefully this will help solve the problem.