Query form multiple search in 1 line

[trident]

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

[June7]

Multiple parameters for one field requires VBA. Review http://allenbrowne.com/ser-50.html

[trident]

Thank you very much for the reply, I will try and get back to you for the result.

Again, Thank you.

Trident