Subform won't update upon reselection of combo box

  • Thread starter Thread starter 8l2255
  • Start date Start date
8

8l2255

I have two linked combo boxes (not sure if this makes a difference),
cbocategoryselect and cboproductselect. cboproductselect controls the record
shown in the subform 'productdetails' however when cbocategoryselect and
cboproductselect are reselected the record does not update accordingly.

Any help would be very welcome.

Cheers
 
8l2255 said:
I have two linked combo boxes (not sure if this makes a difference),
cbocategoryselect and cboproductselect. cboproductselect controls the
record
shown in the subform 'productdetails' however when cbocategoryselect and
cboproductselect are reselected the record does not update accordingly.

Any help would be very welcome.
Click to expand...

In the After Update event of the Combo Box, did you Requery the Subform
Control?

When you write that "cboproductselect controls the record shown in the
subform 'productdetails'", that would lead me to believe that
cboproductselect is the Link Master Fields and a corresponding field in the
RecordSource of the Form embedded in the subform control is the Link Child
Fields -- but there could be other approaches.

Larry Linson
Microsoft Office Access MVP
 
Thanks Larry.

Solved using a requery.

Larry Linson said:
In the After Update event of the Combo Box, did you Requery the Subform
Control?

When you write that "cboproductselect controls the record shown in the
subform 'productdetails'", that would lead me to believe that
cboproductselect is the Link Master Fields and a corresponding field in the
RecordSource of the Form embedded in the subform control is the Link Child
Fields -- but there could be other approaches.

Larry Linson
Microsoft Office Access MVP
Click to expand...
 
Back
Top