Hello Experts:
I understand much has been posted about "refreshing subforms". Yet, based on posted solutions, I still don't seem to be able to address my curren issue.
The attached DB includes the following objects:
1. Table "src_Data" (source data)
2. Query "Q100_ViewData" (row source for subform)
3. Main form "F100_ViewData"
4. Subform "F101_ViewData_Subform"
Existing Process:
- Upon opening the main form "F100_ViewData", select both a) value from radio buttons and b) item(s) from listbox. Then click command button "Execute Query" (EQ).
- Clicking the EQ command button recreates "Q100_ViewData".
- Unfortunately, once I change values for either radio buttons AND/OR listbox, the subform is NOT updated (upon clicking the command button).
I tried all of the six following VBA commands:
Code:
'Forms![F100_ViewData]![F101_ViewData_Subform].Requery
'Forms!F100_ViewData!F101_ViewData_Subform.Form.Refresh
'Forms![F100_ViewData].[F101_ViewData_Subform].Form.Requery
'Me!F101_ViewData_Subform.Form.Requery
'Me![F101_ViewData_Subform].Requery
Forms!F100_ViewData!F101_ViewData_Subform.Form.Requery
Neither of them seem to work for me. Could someone please assist and provide the correct VBA code which will refresh the subform's row source/data once values in radio button/listbox have changed AND I click on the "Execute Query" command button?
Thank you,
EEH