Combo box values

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

Guest

Hi,

I created a table with two combo boxes related to one table with two fields
(Customer and Project). So for each Customer I can have one or more Projects.
Now, I would like to have the values appearing in the second combo box
(Project) related to the choice I made in the first combo box (Customer). I
suppose I have to add some criterias in the SQL Statement of the second combo
box row source, but what will be those criterias? (don't know SQL yet)

Hope my question is clear?

Thanks in advance.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query with results in a value list from a combo box? 1
Combo based on Combo 3
Default Query Criteria 1
Using combo box(s) to create a query 1
Access Control on subform / combo box requesting parameter 0
Union Query 1
Expression for Criteria for Form with Combo Boxes 1
combo box column value in query 7

Back
Top