Find command and combo box values

[Guest]

I have a find icon on my screen that executes DoCmd.RunCommand acCmdFind.

When I am positioned on a combo box that uses a rowsource returning 2
columns how does the find command match the bound column with the displayed
values?
Does it use the current rowsource query? Can I dynamically change this query
before I run the find command to ensure all values are found?

What is happening is that values are not being found. I believe this may be
because my current rowsource does not list them (because they represent
inactive values, e.g. people who have left the company)

 

[Jeff Boyce]

I can't tell, from your description, if the "other" values are stored in the
same column, or in a different column in the same table, or in a different
table?

If you were instructing someone how to "manually" find the other records,
what would you tell them?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

This is standard find command and standard combo boxes.
Combo boxed bound to id (in table) but display text (from query). Obviously
user wants to find on text not on id which user has no knowledge of.
Find command not finding values that definitely exist.
How does find command find text in a combo box when the control is bound to
an id?
My combo box query varies depending on the values of other combo boxes and
whether the user is on an existing record or a new record.
If my current combo box query does not match on an ID, presumably this means
the text will not be found?
How to get around this?

 

[Jeff Boyce]

Is there any chance your underlying table has a "lookup" data type field?
Confusion about what is stored vs. what is displayed often comes up when a
table uses "lookup" data fields.

Regards

Jeff Boyce
Microsoft Office/Access MVP