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

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

Guest

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?
 
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.
 
Back
Top