Form Question

[George Schneider]

I have a form that is based on a query that displays product number, description, p.o. number, received date, received quantity, and purchase price. In addition their a subform for user to enter freight cost, pallet cost, and other charges. What I really want is when this form opens a user can select the product number and all the records that have that product number will be displayed. I've been playing with combo boxes with no luck. Right now I'm using a parameter in the query to type in the value. Any guidance would be most appreciated.

 

[Bill Nicholson]

1. In the query that provides the form recordsource, go to the product
number field and set it to filter on the combo box:

forms!myForm!MyComboBox


2. Go to the form design and add this code to the AfterUpdate event of the
ComboBox:

me.requery


*Do not* bind the product number combo box to a field in the form
recordsource.

Bill Nicholson
nicomp @ yahoo.com

I have a form that is based on a query that displays product number,

description, p.o. number, received date, received quantity, and purchase
price. In addition their a subform for user to enter freight cost, pallet
cost, and other charges. What I really want is when this form opens a user
can select the product number and all the records that have that product
number will be displayed. I've been playing with combo boxes with no luck.
Right now I'm using a parameter in the query to type in the value. Any
guidance would be most appreciated.