Inconsistant Combo box behaviour.

  • Thread starter Thread starter Frank Martin
  • Start date Start date
F

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
 
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
Click to expand...

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]
 
John Vinson said:
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]
Click to expand...


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
 
Back
Top