Prevent users from seeing existing records in forms

[SeanK6876]

I have constructed a database for my fellow employees to request supplies to
be ordered.

I have created a form called "Request Supplies" that they will be able to
access to request them. I do not want them to see existing records because I
know they will just begin to type and overwrite the existing record. I have
tried to set "DataEntry" to Yes, and it works in the ADMIN account but when
you access the form in a USER account the screen comes up blank.

Can anyone help?

 

[Rick B]

Do your users have the ability to add records? If not, the form will be
blank.

Make sure they can add new records.

 

[John Vinson]

I have constructed a database for my fellow employees to request supplies to
be ordered.

I have created a form called "Request Supplies" that they will be able to
access to request them. I do not want them to see existing records because I
know they will just begin to type and overwrite the existing record. I have
tried to set "DataEntry" to Yes, and it works in the ADMIN account but when
you access the form in a USER account the screen comes up blank.

Sounds like the USER account doesn't have the necessary privileges to
update the Form's recordsource query. If a Form returns no records
(which will be the case for a DataEntry form) and also prohibits
updating, you'll get a blank screen. Check that the USER account has
the necessary privileges to update the Form's recordsource.

John W. Vinson[MVP]

 

[SeanK6876]

The only options the Tools>Security>User and Group Permissions gives me for
forms is:

Open/Run
Read Design
Modify Design
Administer

I have Open/Run selected on the group but that still doesn't work. How do I
change their setting so that they can add records?

 

[SeanK6876]

How do I set the privlages so that they can update the recordsource?

 

[Rick B]

Do they have ADD privileges to the table and the query?

 

[Rick B]

Is the FORM's "allow additions" property set to true.

Can the users add records to the table and query upon which the form is
based?

 

[Joan Wild]

Open your form in design view and check the property for RecordSource. Is
it a table? Is it a query?

Users will need Insert Permissions on that table/query.