I have created a Query form which can search by criteria. the following are the options:
Programme Status: - choice BL, U1, U2, U3
Activity Number: - Unique around 400 items
Activity Name:
Report Date:
for the criteria, i can put 1 item per line, how can I get 2 or more choices in 1 line, sample:
Programme Status : BL, U1
Below is the VB i created:
Private Sub Command50_Click()
DoCmd.OpenQuery "QSearchform", acViewNormal
End Sub
Private Sub Command51_Click()
Me.Progress_Status.Value = ""
Me.Activity_No.Value = ""
Me.Activity_Name.Value = ""
Me.Report_Date.Value = ""
End Sub
on the Query form, this is the formula written:
Like [forms]![SearchForm].[Progress_Status] & "*"
Like [forms]![SearchForm].[report_Date] & "*"
Hope you can give me a hand.
Thank you.
Trident