Where Clause in Access Table/Query select statement in combo box
Posted on 2007-12-04
I have a search combo box on a form to pull a record from a table. I would like to select certain records to pull into the combo box based on data (year and location) in the table.
1) I have a form where the user puts in the year and location.
2) then the user clicks on a button that opens a form. The year and location are transferring from the form in #1 to this form.
3) I have a combo box on this second form:
SELECT [tr_hip_no], [tr_name1], [tr_name2], [tr_na_num] FROM transactions WHERE sale_year=me.sale_year And sale_location=me.sale_location ORDER BY [tr_name1];
When I run the form ...it prompts for me.sale_year and me.sale_location.
I also tried: frmtransactions is the form this combox is located:
WHERE sale_year=[frmtransactions].form.sale_year And sale_location=[frmtransactions].form.sale_location