combo box based query

[Guest]

Hi,
I have a form with 3 combo boxes: combo_Category, combo_manufactorer and
combo_model.
I want the 3rd to be based on the other 2

The rowSource for the third combo is a query with the following criteria on
the matching fields

[טפסי×]![frm_cars]![combo_Category]
[טפסי×]![frm_cars]![combo_Manufacturer]

I even put requery statement in afterApdate event

Why isn't it working?
When running the form, I get "fill parameter" popup

 

[Douglas J. Steele]

I'm guessing that you're using a non-English version of Access, because the
first term isn't showing up as Forms in the newsreader. What happens if you
replace that first term with the word Forms?

 

[Guest]

You were right (hebrew)
it works,
thanks

I'm guessing that you're using a non-English version of Access, because the
first term isn't showing up as Forms in the newsreader. What happens if you
replace that first term with the word Forms?

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hi,
I have a form with 3 combo boxes: combo_Category, combo_manufactorer and
combo_model.
I want the 3rd to be based on the other 2

The rowSource for the third combo is a query with the following criteria
on
the matching fields

[?????]![frm_cars]![combo_Category]
[?????]![frm_cars]![combo_Manufacturer]

I even put requery statement in afterApdate event

Why isn't it working?
When running the form, I get "fill parameter" popup