Form Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

George Schneider said:
I have a form that is based on a query that displays product number,
Click to expand...
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.
 
Back
Top