Subform requery

[klwu]

Listbox requery

Hi,

I need some help on this. I have a form that used to display suppliers information, and I have a listbox to display the products supplied by a specific supplier.....what I want to do is that, I want the listbox to requery whenever the user select different supplier....Could someone guide me on this?

I have attached a print screen, I hope you all understand what I mean..

 

[daveUK]

This should automatically happen if the master/child fields are correctly set up between the main form and subform.

Having said that, to requery the listbox manually use the following code on the After Update event of the Supplier Ref No.

Forms!MainFormName!SubformName.Form.ListboxName.Requery