Searching Table Criteria using a Combo Box and Query 1

[aarondewberry]

I have a table with a column called 'Week' in it. Within the rows of that column you might find "week 1, week 2, week 3" in one row, "week 4" in another row, "week 3, week 4" in another row and so on.....
I am trying to use a form called 'Start' with a Combo box, that is linked by a query to search this 'week' column.
If i wasn't using a form i would just put in the query Like "*Week 1*" and it would give me all the rows that contain week 1. But because I am using the form, my query criteria looks like this [forms]![Start]![Week], when I select Week 1 in the combo box, it only gives me the rows that contains "Week 1" on its own and not rows that have more than one week in.
I am sure it is very easy to do but any help would be appreciated.

 

[Remou]

Would this:
[tt]Like "*" & [forms]![Start]![Week] & "*"[/tt]
In the criteria of a query suit?

 

[aarondewberry]

Marvellous!! Cheers Remou, so obviously simply

Thanks again!!