If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Subform won't update upon reselection of combo box
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 |
#2
|
|||
|
|||
Subform won't update upon reselection of combo box
"8l2255" wrote
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 |
#3
|
|||
|
|||
Subform won't update upon reselection of combo box
Thanks Larry.
Solved using a requery. "Larry Linson" wrote: "8l2255" wrote 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 |
Thread Tools | |
Display Modes | |
|
|