Help with ApplyFilter

[kabichan]

I have two forms, frmJobInfo and frmReportGenerator.
When the user selects JobNumber(s) from combobox(es) on frmReportGenerator, I want to display frmJobInfo as Datasheet, displays the JobNumber selected by the user.

E.X.
frmJobInfo

JobNumber JobTitle
-------------------------------------
0001 Computer Lab Assistant I
0002 Computer Lab Assistant II
1001 Office Assistant I
1002 Office Assistant II
1003 Office Assistant III

if the user selects 0001 in combobox 1 and 0005 in combobox 2,
then frmJobInfo display the following information:

JobNumber JobTitle
--------------------------------------
0001 Computer Lab Assistant I
1003 Office Assistant III


---------------------------------------------------------------
Here's my code:

DoCmd.OpenForm "frmJobInfo", acFormDS
DoCmd.ApplyFilter , _
"JobNumber like '*" & Me.cboJobNumber.Value & "*' or " & _
"JobNumber like '*" & Me.cboJobNumber2.Value & "*' "

---------------------------------------------------------------
HOWEVER, MY PROBLEM IS:

This works only when I select a job number in both comboboxes.
If I select 0001 in combobox1 and does not select any in combobox2,
the form does not filter anything, and it display the whole data.



Sometimes I need to filter every job number that start with a specific number, so I need to keep the "*".

I really appreciate it if somebody could help me.
Thank you so much!!
Kabi

[llkhoutx]

I would conditionally build the filter based upon whether one or two fields are being filtered.