Queries with form combo box

[Beeyen]

Good Day,

I have not run a query since Access97 but, I am trying to run a query from a
form that has four different fields with combo boxes. When I select the
fields for the queries the results from the data requested shows up with
numbers as oppose to the information from the record and the combo box field
are empty. It would appear the numbers in the query might be from the primary
key (autonumber).

Could you explain what I might be doing wrong and how and where I should be
making the corrections to return a clean query?

Thank you in advance

 

[KARL DEWEY]

It is very hard to tell you how to fix your query without being able to
actually eyeball it.
Can you open the query in design view, click on VIEW - SQL View, highlight
all, copy and paste in a post?

That way I can see your query.

 

[Beeyen]

Good Day Mr Dewey

Thank you for the quick response. Unfortunately, I am unable to paste the
query. Any idea?

 

[John Spencer]

It sounds as if you need to add the tables that are the source of the
comboboxes into your query and join the tables on the relevant fields.

It seems that you are using the lookup field feature. Unfortunately,
this hides the actual data that is stored and shows you a field from the
related table while storing the primary key value of the related field.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================