I want to be able to have a form, where a certain set of users sees only the screen to add new records - and after they have added a record, they can only see those he/she has added.
Any ideas?
You will need to add a new field to the table in which you can save the UsersID. You will want a login form so you know who is using the db or you will want to use Access Security to select which users can use which forms. Once you have a method of determing who wants access to a form you can then set the forms Data Entry property to Yes (or No) and you can use queries to filter the data so the user asking for information can see only their records.
Search the MS Knowledge Base for SECFAQ.exe for details on how to set up Access Security. This article will show you how to password protect a form...
