Update a Listbox by Combo selection

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

Guest

After update I would like the selection in the combo box to show in the
listbox if there is a selection that belongs to that list box (according to
the query). When I select Sam, if he meets the requirements of the query
then his name will show in the list box. How can this be done?
 
figured it out, in the queries criteria enter the function and dblclick on
the line item from the form you want the information to look up [form]![FORM
name]![Cbox] (this information comes up automatically after double clicking
the field in the function lookup). Then on the list boxes update function
set it to that combobox or field you want it to look up like this;
Me![comboboxname]=Me![listboxname]
Note: The Query will not show any fields when opened, it will only work with
the list box from this point on. Thanks for other examples so I could solve
this...
 
Back
Top