Dependencies on a Query

[Lou_Reed]

In a MS access 2010 db that I am attaching to this post, I modified the name of a query



From

query to set name and address together

To

qryPersonaalNameEmailaddress

that was easy.

I began wondering of all objects that depended on it and if they must be changed.

I used the object dependencies in the Database Tools section and it told me that no form depended
on

query to set name and address together or it new name.

That was nice to know. However, I clearly remember using this query when I built my combo boxes on frmEmail.

The combo boxes clearly have a dependency on that renamed query. However, it is hard to determine even when looking at the properties of the
combo boxes.

I want to know if that name is changed to the new name - in the combo box properties - when I renamed the query.

I know that one should check all dependencies and this one step showed no form were dependent on the query that I renamed, but as I said
the combo boxes are. So should I go in a create new combo boxes and make sure the new query name is used or was this done for in
when I changed the query name?

I noticed when I changed an record name in a table and if that table was used in in a query the record's name was automatically changed.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[jwhite]

Open frmemail in design mode and check the rowsource for the combo box - if it changed it, great; if not, change it.

I may have said it before (and apologize if I did), but I never rely on autocorrect. The first step when handed a database to maintain/update is to first understand what is what in every way. Then when you go about changing things hopefully it will be much easier.

[Micron]

You might want to check out the db documenter for fun. For this question, you'd select all the forms and uncheck all the form control properties options except for 'Data'. The bound field name or sql expression would show for every control on every form selected. A daunting amount of information to be sure, but could be an easier find if you output the report to Word or Excel (ribbon option) and do a Find operation there for key phrases or words.

It wouldn't surprise me to learn that someone has created a db documenter looking for such dependencies but I've never looked for one.