Re: How do I set up a parameter query using a combo box in Access?
- From: "Duane Hookom" <duanehookom@xxxxxxxxxxxxxxxxx>
- Date: Tue, 10 Jan 2006 20:47:59 -0600
Is the form open with a legitimate value in the combo box? Are you sure the
combo box bound value is what you expect?
You can find out the actual value of the combo box by opening the debug
window (Press Ctrl+G) and enter:
?[Forms]![Form1]![Combo0]
Do you see the expected value when you press enter to get the value?
--
Duane Hookom
MS Access MVP
--
"Ryan" <Ryan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FDA33631-9053-4DB7-B83E-9C4A9E7AE27A@xxxxxxxxxxxxxxxx
> How do I use the value in a combo or list box limit a query or report
> query?
> I have tried two options with no success. They are as follows:
>
> Option 1: Set up a query with the criteria pointing to the combo or list
> box
> value. The criteria reads =[Forms]![Form1]![Combo0]
> Option 2: Set up a macro opening a report with the "Where" condition set
> to
> limit the result by the combo or list box value. The "Where" condition
> reads
> [HouseAddress]=[Forms]![Form1]![Combo0]
>
> Each time the report/query comes back blank.
.
- Prev by Date: Re: How do I set up a parameter query using a combo box in Access?
- Next by Date: Re: CREATE TABLE: how to define a field's DEFAULT data value?
- Previous by thread: Re: How do I set up a parameter query using a combo box in Access?
- Next by thread: Re: How do I set up a parameter query using a combo box in Access?
- Index(es):
Relevant Pages
|
