**Query From Form Text Boxes**

[TallMan]

Good Afternoon,

I have two make table queries in which I would like to control from a form.

What I am trying to do is have a form with mulitple text boxes on it:

Tax id, Symbol, CUSIP, Account.

I need to have four text boxes on a form that relate to a query. Not all of the text boxes will always be populated as well as some of them will have multiple criteria (i.e symbol = GE, AAPL, MSFT)

The main problem I am having is all of the different ways this information can be entered. For example, the associate may only have Cusip and tax- id and not symbol and account so as soon as the text boxes for account and symbol are blank the underlying query does not pull any information.

Also, If I enter in more than one tax id using ("111-11-1111", "222-22-2222") with a symbol I know is in both accounts I do not get anything. When I go to the underlying query to try the same criteria I pull information.

I made sure I am using the Load form function when placing the criteria in the underlying query.

Does anyone know the most effecient way to do this or could you point me in the right direction?

Thanks Guys and Gals!!!!

 

[TallMan]

Hey Guys,

I have also tried to search the forums for similar posts but have been unable to find anything. If you know of any related forums could you send it my way?

Thanks for all your help.

 

[Brianwarnock]

If This

The main problem I am having is all of the different ways this information can be entered. For example, the associate may only have Cusip and tax- id and not symbol and account so as soon as the text boxes for account and symbol are blank the underlying query does not pull any information.

were your only problem then it would be answered here

http://www.access-programmers.co.uk/forums/showthread.php?t=103312

However the multiple criteria in one textbox is a more difficult issue, normally when hardcoding one would use IN but you cannot handle that without using code, it has been discussed on the forum but finding it is difficult. I think one has to build the SQL in the code.
Try searching on multi-select.

Brian