Subform won't update upon reselection of combo box

[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

 

[Larry Linson]

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.

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

 

[8l2255]

Thanks Larry.

Solved using a requery.

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