It might depend on how you put the filter on. Did you actually use the Filter property of a form?
How do you execute the search?I don't recall using the filter property of the form.
Is the data being returned to be aditable?
How do you execute the search?
Why not use a list box instead os a subform?The data returned (recordset) is not editable.
Was done by design. The main user is able to edit the data but the other users can return data but not edit.Why not use a list box instead os a subform?
Can you post that VBA code? I am guessing you may be using the Filter property there.Through my searchboxes and dropdowns (use VBA), they work in tandem to filter through my data. Unless I was confused by Isaac's comments, I thought he was referring to a form property for the filter, but I do not recall altering any form properties for the filter.
Hi. Thanks for posting a copy of your db. Check out the attached modified version.Hi theDBguy,
I just posted a sample of the DB. As you can see, I filter the data through my dropdowns/search boxes. The "clear" button is the button that I would like to use to clear both the search filters and the record/output. So far I'm able to clear the 4 search filters but not the output.
Thank you.
Hi. Thanks for posting a copy of your db. Check out the attached modified version.
You're welcome. We were all happy to assist. Good luck with your project.This is excellent. Thanks again for your help theDBguy! Much appreciated!