table problems

S

Susan

Trying to query a table with a drop down list and won't give me that info-
(where it is a + and click on it -, and get hidden info). Does anyone know
how to retrieve it? I don't know why anyone would set up a table like this-
maybe it's just an older version of Access? Please help me solve this
problem, would be very much appreciated. Thanks!!
 
B

Bob Waggoner

Are you looking at a table or a form? If a table, open in design view and
click on the field in question. Look at the bottom of the form and click the
Lookup tab. Your query or table that the field is drawing from should be in
the Row Source.

If its a form, go into design view. Click on the control and get the
properties box up. Look for the row source under the all tab. That's where
your information is coming from.
 
J

John W. Vinson

Trying to query a table with a drop down list and won't give me that info-
(where it is a + and click on it -, and get hidden info). Does anyone know
how to retrieve it? I don't know why anyone would set up a table like this-
maybe it's just an older version of Access? Please help me solve this
problem, would be very much appreciated. Thanks!!
Click to expand...

This is actually a feature (a lot of us consider it a misfeature!) added,
IIRC, in AccessXP - it's called a Subdatasheet (and the drop down list is
called a Lookup Field). See
http://www.mvps.org/access/lookupfields.htm
for a critique.

You can create a Query joining your table to the lookup table (find it on the
Lookup tab for this field) to see the actual contents of both tables.
 
Top