Cannot enter data in subform

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

Guest

I have a subform on a form. The only visible object on the subform is a
textbox. When I login as the user who owns all the objects in the db,
everything works fine. However, when I log in as a user, I cannot edit the
textbox on the subform.

The textbox is enabled and NOT locked.

Allow Edits / Deletions / Additions is set to yes for the subform.

The record source for the subform is a SQL statement that queries a table

Any ideas why I cannot edit the textbox???
 
Well, I changed the Record Source from a SQL statement to a Query...and now
it works perfectly. Can anyone explain why?
 
The Query RunPermissions property is probably set to Owners: All users are
allowed the owner's permissions to view or run the query.

Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.
 
Back
Top