Requery subform control to refresh list based on combo box value change

L

Larry Kahm

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
 
L

Larry Kahm

Issue resolved.

Removed the links between main form and subform. Changes to the value in
the combo box (afterupdate .Requery) now works.

Larry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top