Desperately seeking knight in shining armour

[jazjam]

I'm having difficulty in knowing where to start.

I want to design a query by form to selecting several or some items from Combo box's: Client, JobID, Ops Controller, Nominal Code and Sales (all from seperate list tables),

and use toggle boxs for the Status selection which needs to include a toggle box for "ALL"

Any help would be greatly received, I have tried to read up on this but find myself punch drunk and still none the wiser.
JazJam :-(

 

[llkhoutx]

Build and execute your query via VBA code.

 

[Jack Cowley]

This article will show you how to do what you want and is not as bad as it looks. And you should not need toggle buttons....
http://support.microsoft.com/support/kb/articles/Q136/0/62.asp?LN=EN-US&SD=gn&FR=0&qry=q136062&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC97

 

[jazjam]

Thanks Jack I down loaded the samples helped a lot. Decided to use a filter form with the reports.

IIkhoutx a novice at VB its a case of knowing what I want but not knowing how or which coding to use.

Thanks guys always wanted a knight in shining armour. Hope you professionals don't think me thick, its great to pick the brains of the elite.

Take care till we communicate again. All the best

 

[Jack Cowley]

We do not think you're thick! Remember that not a single one of use was born knowing how to use Access. We all had to learn it just like you are doing so please feel free to come back and ask all the questions you like. And there is no such thing as a dumb question....

 

[jazjam]

Thanks Jack that means alot, and yes I will more than likely be visiting alot.

All the best
Jazjam