Combo box and parameter query

S

Stukmeister

I have a combo box ProjectIDBox in the Parent of a Tab form Form01 and a
query Q1_Project. The table Project has key fields ClientID and ProjectID and
the query has a parameter of [forms]![Form01]![ClientID] for selection on the
ClientID field.

In the form, I want to pass the ClientID to the query and have the query
list only the projects associated with that client.

The queried pops up with the combo box, but it always has the same Client
ID. What's up?
 
M

Marshall Barton

Stukmeister said:
I have a combo box ProjectIDBox in the Parent of a Tab form Form01 and a
query Q1_Project. The table Project has key fields ClientID and ProjectID and
the query has a parameter of [forms]![Form01]![ClientID] for selection on the
ClientID field.

In the form, I want to pass the ClientID to the query and have the query
list only the projects associated with that client.

The queried pops up with the combo box, but it always has the same Client
ID. What's up?
Click to expand...


I have no idea what "in the Parent of a Tab form" means. If
you are trying to synchronize a subform with a control on a
main form, you should use the subform control's Link
Master/Child Fields properties instead of messing with the
query.
 
Top