I set up a combo box to allow users to search through product options and I have a filter options box that will allow them to select a specific product type. The problem is that inorder to make them work I had to go into the form properties and reset my for to Allow Edits. Once I get all of the data entered I do not want anyone to be able to edit any information in the database except me. What's a good way to get around all of this. If I reset the Allow Edits to NO then the combo box and filter options don't pull in the information requested?????

Please help - I'm almost done with this project!!!!!!

MG:

You might try this:

-set the form's allowedits property to false

- in the combo box's "On GotFocus" event set allowedits to True

- when the combo box's "On LostFocus" event set allowedits to False

To allow yourself to edit the form's data you'll have to do something to change the form's AllowEdits property OnOpen if it's you that's opening it. How do you know it's you? Depends on what security you're using. If you are using Access' built-in userID/password you could check

If UserID() = "MeisterGirl" then Me.AllowEdits = True ' in the Form's OnOpen event

Jim