How to create a query based on an existing value in a form field

A

Anthony

Newbie: I have two combo box fields on a form, Fund and Line Item. When I
select the appropriate Fund on the form and tab over to the Line Item Combo
box. I would like to create a query for the Line Item Combo box to locate
the appropriate Line Item that is related to the Fund in the previous field.
How do I use the data from the Fund field in the form in the query for Line
Item?
 
A

Allen Browne

If you are trying to restrict the LineItem combo show it only shows items
that relate to the value selected in the Fund item, see:
Limit content of combo/list boxes
at:
http://www.mvps.org/access/forms/frm0028.htm

Note that if the subform is in continuous or datasheet view, and the bound
column of the LineItem combo is hidden (zero-width), Access will not be able
to show you the desired names for the line items on the other rows of your
subform.
 
Top