Update a subform bassed when a combobox is changed. (1 Viewer)

[mjones]

I have a form that consists of the main form with a subform that is a datasheet of invoice details for paying membership fees (Invoice Date, Amount, Membership Year etc.)) . What I want to happen is when I change the value of a Combobox on the main form, the subform displays only the invoices for the selected year (the MembershipYear field is just a number). I have modified the query that runs the subform (qryDisplayMembersFees) so that when I change the Combobox and re-run the query it works, but I can't get it to update the subform using the .requery command.

Thanks

Matt

 

[theDBguy]

Hi Matt. Have you considered simply linking the subform to the combobox (in addition to the PK, of course)?

PS. Sorry, can't download your file right now.

 

[bob fitz]

...........but I can't get it to update the subform using the .requery command.

Thanks

Matt

Can you show us the the code you are using.

 

[Gasman]

Hi Matt. Have you considered simply linking the subform to the combobox (in addition to the PK, of course)?

PS. Sorry, can't download your file right now.

@theDBguy
I would not bother, it only contains

and

 

[theDBguy]

@theDBguy
I would not bother, it only contains
View attachment 78630
and View attachment 78631

Thanks for letting me know!