Hi,
I have a form with a subform. On this subform i have a report and a list box.I want to be able to click on the listbox item and then display the record details in the report.
I have tried this code:
DoCmd.OpenReport "Report", acViewPreview, "[ID] =" & lst_Items.Column(0)
but because the report is on the subform, i dont want to "OpenReport" / populate a report - i want the report on the subform to refresh based on the listbox selection
Thank you so much
I have a form with a subform. On this subform i have a report and a list box.I want to be able to click on the listbox item and then display the record details in the report.
I have tried this code:
DoCmd.OpenReport "Report", acViewPreview, "[ID] =" & lst_Items.Column(0)
but because the report is on the subform, i dont want to "OpenReport" / populate a report - i want the report on the subform to refresh based on the listbox selection
Thank you so much