User can not add data to form

G

Guest

I have an access database and set up some user level security. As the Admin I
have complete access to everything. I have set up a user with exactly the
same rights as me. However, when I open the database as this user I can not
add data to a form. The form contains combo boxes. As this user I can click
on the combo box to show the drop down but when I click on an option, that
data is not inserted into the field on the form.

Please does anyone have any ideas? Thanks
 
J

Joan Wild

It sounds as though the user has Open/Run permissions on the form, but does
not have sufficient permissions on the recordsource of that form.

Is the record source a query or table? Check the permissions on that -
they'll need Insert permissions.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Sub form opens before the main form in MS Access 0
How to use multiple command button to copy user form data to multiple worksheet 0
Access MS Access Listbox not saving to bound field 0
user permissions 4
User level Access 1
Excel Concatenate Form Name to Parse for function 1
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
User can not add/change data on a form... 3

Top