Search results

I have a database which comprises 6 tables which are linked by 1 field. This field can only ever have 44 unique entries. However I want to produce a query which has a criteria using only 1 or all 44 or any combination of multiples in between. I know how to write the query the long way, but...

Thanks for that, but, the form which the buttons are on which fills the variables is still open, I can't see that putting the variables on a hidden form is any different. I will however try it. You may detect from the tone that I am slowly losing the will to live.

This is driving me crazy. I have declared my variables as public within a module which contains a some functions. I am then using some of the variables from a form procedure. The variables which are referenced from the form have all lost their contents when i need to use them in the module...

Thanks for the hint. I'm still not certain what you mean can you supply any more info or an example

I've been trying to do this for days and get get it to work. Question is can I do it and if so how.