Dynamic criteria

  • Thread starter Thread starter Thomas Wright
  • Start date Start date
T

Thomas Wright

I want to write an SQL query where on of the WHERE
statments returns the result of another combo box on the same form. I would
think this would be common practice but I can not find it.

Any advice?

Tom Wright
 
Need clarification:

Do you want the WHERE clause to use the value of the combo box? Or do you
want the combo box's RowSource to be th results of the query?
 
Yes, I want the WHERE clause to use the value of the combo box.

Thanks,

Tom Wright
 
Back
Top