query in row source for a combo box

[Guest]

Hi,

I have a combo box that has a query for it's Row Source. Maybe there's a
bug, but I can't erase this query to replace with another query. When I do,
the form will not close or when I reopen the database, the original query
shows up in the the Row Source.

I'm using Access 2007.

Please help!
Thanks,

 

[Hunter57]

Hi,

I have a combo box that has a query for it's Row Source. Maybe there's a
bug, but I can't erase this query to replace with another query. When I do,
the form will not close or when I reopen the database, the original query
shows up in the the Row Source.

I'm using Access 2007.

Please help!
Thanks,

Hi ProjectUser,

I could be likely that there is some VBA code or a macro that is
replacing the RowSource when you reopen the database or form. I often
use VBA to change a RowSource depending upon whether a text box is
null or a checkbox is checked.
Fortunately, you can search VBA easily in the VBA Editor by using Find
on the menu bar and searching for the name of that pesky query! Be
sure to select the option to search the Project and not just the
module or proceedure.

If you do not find it there then a macro may be replacing the query
name. Unfortunately, I do not know how you can search macros except
by opening them one at a time searching for the name of the query.
Perhaps someone else can tell us an easier way to do that.

Happy Hunting!

Hunter57