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

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.

--
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 Removed)



"Christina" <(E-Mail Removed)> wrote in message
news:13BAAB8D-C534-4731-B00D-(E-Mail Removed)...
> 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" <(E-Mail Removed)> schreef in bericht news:UosDf.2767$(E-Mail Removed)...
> --
> 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 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

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)




"PC Datasheet" <(E-Mail Removed)> wrote in message
news:UosDf.2767$(E-Mail Removed)...
> 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.
>
> --
> 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 Removed)
>
>
>
> "Christina" <(E-Mail Removed)> wrote in message
> news:13BAAB8D-C534-4731-B00D-(E-Mail Removed)...
> > 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
>
>