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