Hi all,
I've created a form, frmTechniqueAllocate that displays data from the query qryTechniqueMasterFilter
On the form I have 4 unbound text boxes, the idea behind these is to allow the user to progressively filter the results to find what they need:
Unbound text boxes:
CustomerFilter
DescriptionFilter
Drg-PattFilter
JobNoFilter
The idea is the user can input into any of the above boxes and the form filters the results accordingly.
However, the one caveat to this is the Drg-PattFilter, which I need to look across two separate fields in the query.
I'm struggling with the criteria to get this to work correctly, I'm using the len function to deal with nul fields.
So in the first row of criteria I have the following across fields:
TechCustomer
TechDescription
TechDrawingNo
Jonno
then in the second criteria box for TechPatternNo I have
At the moment this isn't functioning as expected, I thought I had it working, but now only the fields TechDrawingNo and TechPatternNo will filter.
Any advice / help appreciated.
I've created a form, frmTechniqueAllocate that displays data from the query qryTechniqueMasterFilter
On the form I have 4 unbound text boxes, the idea behind these is to allow the user to progressively filter the results to find what they need:
Unbound text boxes:
CustomerFilter
DescriptionFilter
Drg-PattFilter
JobNoFilter
The idea is the user can input into any of the above boxes and the form filters the results accordingly.
However, the one caveat to this is the Drg-PattFilter, which I need to look across two separate fields in the query.
I'm struggling with the criteria to get this to work correctly, I'm using the len function to deal with nul fields.
So in the first row of criteria I have the following across fields:
TechCustomer
TechDescription
TechDrawingNo
Jonno
Code:
Like IIf(Len([Forms]![FrmTechniqueAllocate]![CustomerFilter])=0,"*","*" & [Forms]![FrmTechniqueAllocate]![CustomerFilter] & "*")
Like IIf(Len([Forms]![FrmTechniqueAllocate]![DescriptionFilter])=0,"*","*" & [Forms]![FrmTechniqueAllocate]![DescriptionFilter] & "*")
Like IIf(Len([Forms]![FrmTechniqueAllocate]![Drg-PattFilter])=0,"*","*" & [Forms]![FrmTechniqueAllocate]![Drg-PattFilter] & "*")
Like IIf(Len([Forms]![FrmTechniqueAllocate]![JobNoFilter])=0,"*","*" & [Forms]![FrmTechniqueAllocate]![JobNoFilter] & "*")
Code:
Like IIf(Len([Forms]![FrmTechniqueAllocate]![Drg-PattFilter])=0,"*","*" & [Forms]![FrmTechniqueAllocate]![Drg-PattFilter] & "*")
Any advice / help appreciated.
Last edited: