Inconsistant Combo box behaviour.

[Frank Martin]

Usually on a form I can link a subform to a combo box using the child/master
fields in the subform's property box.

But sometimes this does not work.

Please help, Frank

 

[John Vinson]

Usually on a form I can link a subform to a combo box using the child/master
fields in the subform's property box.

But sometimes this does not work.

Please help, Frank

Please help, Frank. Under what circumstances does it not work? Give us
an example please!

The Child property *must* be a fieldname in the subform's
Recordsource; it cannot be a control name. The Master (in my
experience) can either be a fieldname or the name of a control which
has a Value property (i.e. you cannot use a Label or a Multiselect
Listbox or the like), but a combo should be fine.

John W. Vinson[MVP]

 

[Frank Martin]

Please help, Frank. Under what circumstances does it not work? Give us
an example please!

The Child property *must* be a fieldname in the subform's
Recordsource; it cannot be a control name. The Master (in my
experience) can either be a fieldname or the name of a control which
has a Value property (i.e. you cannot use a Label or a Multiselect
Listbox or the like), but a combo should be fine.

John W. Vinson[MVP]

Thanks, I got it working, but only after I constructed a combo box manually.
The Combo wizard kept giving a "problem with sql FROM statement" error.
The row source for the combo is a query with several IDs.
There was nothing wrong with the Child/Master fields.
Regards,Frank