Unbound TextBox and Report Criteria

[FabHead]

I have a query built and a field named WaferType. WaferType consists of four possible entries called: WarmUP, Product, Monitor, and Maintenance.

Now if I enter in the criteria box of the query under WaferType the following: "WarmUP" Or "Product" Or "Monitor" Or "Maintenance" the report returns the correct records (this was just a test to see what I need in the criteria box). I have 4 checkboxes in a form to select the criteria for this report. The checkboxes are associated with the four above wafer types. I also have a unbound textbox that is based on the checkboxes.

The unbound text box is called WBT, I have code to put in the text box this: "WarmUP" Or "Product" Or "Monitor" Or "Maintenance" which is the same if I type it in the criteria box itself, but I get a 'No Data' message. In the criteria box under WaferType is the folloung:
[forms]![WBRC]![WBT]

One other note, it works fine with just one selection. If I code it: Me.WBT.value="WarmUP"
That works fine, the problem I am having is how to use an unbound text box to get any or all four selections of WaferType in the criteria box to work.

 

[Rolliee]

To answer your question, on event afterupdate in the unboundtext box code in me.wbt = me.text? - whatever name the textbox is. I would use a combo box or list box to do this tho since you have a limited number of entries.

rollie@bwsys.net

 

[FabHead]

Problem with using a combo or list box is it alows me only one selection. I want to use 1,2,3 or all 4 possibilities to filter the records I want.

The unbound textbox is called WBT.

 

[Rolliee]

Use the combo box's to fill unbound textboxes anmd those to buiuld the query.

R