I have a subform linked to data in a separate table to the main form. The data in the subform is linked to the main form by using the ID of an individual. If I select an individual from a drop down box I can requery the listbox (which contains the key data I want displayed) on the subform using:
Forms!rmChildData.subfrmChildServicesSelector.Services.Requery
However, if I click on a Refresh button (using an On_click event) I have put on to the main form or just scroll through records using the navigator button at the bottom of the screen, I can't get the listbox to update using this code.
Any ideas, please? I'm sure it's so obvious!
Many thanks
John R
Forms!rmChildData.subfrmChildServicesSelector.Services.Requery
However, if I click on a Refresh button (using an On_click event) I have put on to the main form or just scroll through records using the navigator button at the bottom of the screen, I can't get the listbox to update using this code.
Any ideas, please? I'm sure it's so obvious!
Many thanks
John R
