URGENT! combobox item not selectable + others

[snipe]

Hey guys,

This is somewhat of an emergency.

I have a form:

The user selects a a person from the combobox, the after event code first to requery a subform. This works great for me as the admin. My normal data users can't select the item. The text boxes (Type of Name, Ad Date) pull their data directly from this programs switchboard form. Those don't retrieve data either. Here is the design view of the form, and what the normal data users see..




I have been googling for an hour and I have found 4 things:
Form - Allow Edits needs to be yes
Cbo- enabled = yes and locked = no...mine is correct
control source property is linked to a query, that the normal data users have been given full access to, just for testing.


Checked bound column... obviously is set correctly since it works for me as the admin.

I am stumped.....

Please help!


Also:

I have tried removing the cbo and the subform. Those data fields in the black box won't populate. I have tried removing the subform and trying to select something in the cbo, still doesn't work. There is no code in the events on the form it self.

[snipe]

Not so urgent now. I added the "normal users" user account to the admin group. It works for them now. But I don't want them to permanently have full access to this whole program. Still need to fix this.

[burrina]

Do you not have a Login form with security? Unsure of your needs or how many users,or your security setup etc...

[snipe]

I am using a secured.mdw to handle login procedures. I inherited most of my databases and I just learned to roll with them instead of trying to remake them. This where I go to manage security. I ended up removing permissions from the normal users 1 by 1 late last night and finally got it narrowed down. I still don't entirely know what caused the issue, but all is good now.