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?

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"AlanW" <(E-Mail Removed)> wrote in message
news:01894361-A68F-4156-802C-(E-Mail Removed)...
>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?

AlanW wrote:

>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.

--
Marsh
MVP [MS Access]