Refresh / Requry Subform Upon Combobox Change

[michael.legge@rbc.com]

Hi, I have been using AYS2000 database example from Rogers access library. I have been in the process of modifying to meet my needs. Although I have run into a problem that was prevalent in the original database example. I have attached the original database for your reference.

Problem: At the bottom of the database beside the "New Response" button there are 2 combo boxes that allow you to select the survey and response in which you want to view in the subform. Although when selecting the response the subform does not always update the record in the subform. It would appear that the problem occurs only after a response has been previously selected. I have tried adding additional code to refresh and requery the subform already without any success. I feel like there should be an easy solution to this problem.

Any help would be greatly appreciated!!

Thank you
Michael

[michael.legge@rbc.com]

All data is dummy variables. No sensitve information.

[rzw0wr]

I did not see a problem.
Appears to work well for me.

Dale

[michael.legge@rbc.com]

If we take the Survey "Knee Follow-up Form" for example and click through Dave Duane and Tanya in that order, the 3 responses that are available, when you would like to return to Dave of Duane the information in the subform stays populated at Tanya and no further updates can be made without first changing the "Find Survey" field. I would like the subform to always update when switching between responses. Hopefully that provides some clarity.

Thank you
Michael