How to use the requery in the form

[Guest]

I have a list which contains several suppliers and each of which has its own
products. How can I narrow the product selections after choosing particular
supplier. Is it right to use requery function?

 

[Allen Browne]

You need to programmatically set the RowSource of the Product combo, in the
AfterUpdate event of the Supplier combo.

Details:
Limit content of combo/list boxes
at:
http://www.mvps.org/access/forms/frm0028.htm

 

[Marshall Barton]

I have a list which contains several suppliers and each of which has its own
products. How can I narrow the product selections after choosing particular
supplier. Is it right to use requery function?

Assuming the products combo box's RowSource query uses the
supplier combo box in its criteria, then, yes you would use
Requery with this kind of code in the supplier combo box's
AfterUpdate event procedure:

Me.cboProducts = Null
Me.cboProducts.Requery

You will probably want to use the requery line in the form's
Current event too.