listbox question

[badangel]

Hi everyone

I have a form with a listbox on the left hand side and a suform on the right hand side. How do i get the records in the subform to change to the corresponding record when i select an item in the list box. I have got it so that I can open a new form with the correct info in but I just want the subform to change. Help!! Thanks in advance.

 

[Schof]

Have you tried to include the listbox control in the subform's Link Master Fields property and linked it to a corresponding field in the subform's Link Child Fields property? If so then I believe the subform should automatically change when the listbox does.