Solved Click on listbox item and requery report on subform? (1 Viewer)

[inkbird01]

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

 

[Josef P.]

Connect the subreport to the listbox.

LinkMasterFields: YourListbox
LinkChildFields: ID

 

[inkbird01]

Connect the subreport to the listbox.

LinkMasterFields: YourListbox
LinkChildFields: ID

Thanks for your reply but i get an error " Can't build a link between unbound forms "

 

[Josef P.]

Simply insert the text manually.

 

[inkbird01]

O

Simply insert the text manually.

ok, when i click on the listbox item nothing happens to the subform?

 

[inkbird01]

ohh it is working now thank you!