A
abdul wahab via AccessMonster.com
Hi,I shall be grateful for any help.
My problem
Tables:
Cars
Customer
Invoice
TblMake
Tbl Model
I have used cascading combos for Make and Model. They work fine.
I used to be able to search using "Make" or "Model" or "Colour" or all of
them - but now I have put a JOIN query, I can only search for "Make". If I
try and search for "MODEL" it makes me have to enter both details in. Is
there any way to get around this.
p.s. I have set the record source for the textbox to the JOIN query. In
this query I have this entered in the "MAke" criteria:
Forms!FrmSearchNew!cmbMake
As I said, it works fine for the "Make", but if I do the same thing for the
"Model" - it wants both - and cannot work with just the "Make"
Thank you very much
My problem
Tables:
Cars
Customer
Invoice
TblMake
Tbl Model
I have used cascading combos for Make and Model. They work fine.
I used to be able to search using "Make" or "Model" or "Colour" or all of
them - but now I have put a JOIN query, I can only search for "Make". If I
try and search for "MODEL" it makes me have to enter both details in. Is
there any way to get around this.
p.s. I have set the record source for the textbox to the JOIN query. In
this query I have this entered in the "MAke" criteria:
Forms!FrmSearchNew!cmbMake
As I said, it works fine for the "Make", but if I do the same thing for the
"Model" - it wants both - and cannot work with just the "Make"
Thank you very much