Prevent users from seeing existing records in forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Do your users have the ability to add records? If not, the form will be
blank.

Make sure they can add new records.
 
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.
Click to expand...

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]
 
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?
 
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?
 
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.
 
Back
Top