how to create combo box in form to input criteria in a query

[Guest]

Dear All,
I have a combo box in a form linked to a query / report. Both the query and
report work. However when I choose a criteria from the combo box, eg a name,
the report brings no data. Please if any one can help, I would be grateful.


Thanks
Christina

 

[PC Datasheet]

Start by looking at the Bound Column property of the combobox and be sure
the value of the combobox is really what you want for the criteria. For
example, the boundcolumn of a combobox is usually 1 and therefore the value
of the combobox is the ID field of the rowsource. If you are using an
autonumber in the rowsource, the value of the combobox will be a number. If
you are expecting a name in the criteria of the query, you're getting a
number from the combobox and consequently the query will not return any
records.

 

[StopThisAdvertising]

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1100 users have come to me from the newsgroups requesting help
(e-mail address removed)

--
To Steve:
Over 325 users from the newsgroups have visited the website to read what kind of a 'resource' you are...

To the original poster:

Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html (updated)

Arno R

 

[Rob Oldfield]

To the original poster:

Most people here have a common belief that the newsgroups are for *free
exchange of information*.
But Steve (PC Datasheet) is a notorious job hunter in these groups, always
trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html (updated)