Im new in this and I need some help

  • Thread starter Thread starter V1ntage
  • Start date Start date
V

V1ntage

Im trying to write a database for a uni project. What I want to do is to use
combo boxes as the data selectors for my queries, but I cant do it. In
another words, what I want is to have a for with 4 or 5 combo boxes
(dropdown boxes) and then press a button and the quiry will search the
server with those parameters.

Do I make any sense?

Thx in advanced
 
Let's say that you have a query that searches for particular records based
on the value of a combo box on your form named cboCountry. In your
Query's design view, go to the column for Country. Enter the following in
the Criteria row:

Forms!MyForm!cboCountry

Here is a KB link to information about using Query by Form techniques:

ACC2000: How to Use the Query by Form (QBF) Technique
http://support.microsoft.com/default.aspx?scid=kb;en-us;209645

If you are not using Access 2000, there are links in the article for other
versions of Access.
 
Back
Top