I have made a form and are able to open the query with a drop down box selection. It only works if I put in all the correct information but I want to use the * wild card to bring in more information as below.
Field contains values FS1A12 FS1A11 FS2A13 FS2A15 BA1A5 and so on.
I have created a table that contains FS* and FS1A12 FS1A11.
If I select FS* my query returns no records but if I select FS1A12 i get that record.
I want to select FS1* and get all the FS1 records
I have used [Forms]![Search]![Combo0] as Criteria in my Query and think that I need to add a LIKE but can not work out where to put it.
Field contains values FS1A12 FS1A11 FS2A13 FS2A15 BA1A5 and so on.
I have created a table that contains FS* and FS1A12 FS1A11.
If I select FS* my query returns no records but if I select FS1A12 i get that record.
I want to select FS1* and get all the FS1 records
I have used [Forms]![Search]![Combo0] as Criteria in my Query and think that I need to add a LIKE but can not work out where to put it.