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
|
|||
|
|||
Requery subform control to refresh list based on combo box value change
Main form: frmArticles
Combo box with project numbers: cboProjectID. Subform: sfrmStaff (control is isfrmStaff). sfrmStaff is linked to frmArticles by project number. Recordsource for subform is a query that uses a criteria of Forms!frmArticles!cboProjectID When I change the value of the project number in the combo box, I expect to have the contents of the subform update. I've included the following statement in the AfterUpdate event for the combo box: Me!isfrmStaff.Form.Requery. However the contents of the subform are not updated. What else should I be looking at to correct this? Thanks! Larry |
#2
|
|||
|
|||
Requery subform control to refresh list based on combo box value change
Issue resolved.
Removed the links between main form and subform. Changes to the value in the combo box (afterupdate .Requery) now works. Larry "Larry Kahm" wrote in message ... Main form: frmArticles Combo box with project numbers: cboProjectID. Subform: sfrmStaff (control is isfrmStaff). sfrmStaff is linked to frmArticles by project number. Recordsource for subform is a query that uses a criteria of Forms!frmArticles!cboProjectID When I change the value of the project number in the combo box, I expect to have the contents of the subform update. I've included the following statement in the AfterUpdate event for the combo box: Me!isfrmStaff.Form.Requery. However the contents of the subform are not updated. What else should I be looking at to correct this? Thanks! Larry |
Thread Tools | |
Display Modes | |
|
|