Connecting Tech Pros Worldwide Forums | Help | Site Map

How do I pass the value from a list box into a query?

Jelena
Guest
 
Posts: n/a
#1: Nov 13 '05
PLEASE HELP!

Paul
Guest
 
Posts: n/a
#2: Nov 13 '05

re: How do I pass the value from a list box into a query?


Assume that the form the listbox is on is called Invoice and the listbox is
called Supplier

In the query, add a Supplier field. in the Criteria section add the
following: [forms]![Invoice]![Supplier]

thats it.

HTH
Paul


"Jelena" <jmarinkovic_knn@hotmail.com> wrote in message
news:b1fe9d76.0411040548.41aaa7f7@posting.google.c om...[color=blue]
> PLEASE HELP![/color]


Closed Thread