Combo Box - Can't find source?

[Jason O]

Hi,

I wonder if anyone could help. I'm trying to familiarise myself with a
database that a former member of staff set up. Its purpose is to collect
telephone survey information, and as such one of the main fields is the
staff member's initials. This same field is in a number of tables, and is
called 'CAPContact'.

The main form in the database (among others) contains a combo box with the
following properties:

Row Source Type..Table/Query
Row Source......SELECT DropBox_CapContact.CAPContact FROMDropBox_CapContact;

My problem is (and I may be being a bit slow) that I cannot find the source
data for the combo box. My (limited) understanding was that a combo box can
either refer to another table, or a list of options the user types in when
setting it up. In the above example I cannot find a dedicated table with
the staff initials in or find anywhere where the list is detailed. I know
there *is* data as when the form is opened there are 15 sets of initials in
the combo box. What does the above row source mean? Any ideas where I can
find the list of staff intitials that is behind this box?

Sorry if I'm missing the blindingly obvious & any help greatly appreciated.

TIA

-J-

 

[John Spencer]

Did you look for a query with that name "DropBox_CapContact"?

It also could be a hidden table or a hidden query.

 

[Jason O]

I checked all visible queries/tables and also went to unhide & there weren't
any items hidden. If the source table/query is hidden is that how I'd find
out - unhide?

Jason
___

 

[Keith Wilby]

I checked all visible queries/tables and also went to unhide & there
weren't
any items hidden. If the source table/query is hidden is that how I'd
find
out - unhide?

Tools, Options, "View" tab, "Hidden objects" check box.

Regards,
Keith.
www.keithwilby.com