combo box not working on subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have found similar problems in the group, but the answers didn't exactly
help me.

I have built a set of forms for data entry which will be used as subforms on
a larger tabbed form. My subforms have mostly combo boxes which are linked
to queries. For example, in the first box I select the item that I need.
The second box then shows the price for that item. I used the "On Change"
event in the first box to run a macro that requeries the second box so that
it changes when I change selection. All of this works great on the actual
form. However, when I go to the larger form, the second box, for the price,
doesn't work. I get the dreaded "Enter Parameter Value" dialog.

Anyone have any ideas on how to fix this?
 
You must reference a subform's control via the main form. Your combo box's
Row Source Query needs to be changed so that it uses the correct reference:
Forms!MainFormName!SubformName!ControlNameOnSubform

where SubformName is the name of the main form's subform control (the
control that actually holds the subform object).
 
Back
Top