View Full Version : Desperately seeking knight in shining armour


jazjam
02-27-2001, 08:33 AM
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
02-27-2001, 01:14 PM
Build and execute your query via VBA code.

Jack Cowley
02-27-2001, 04:27 PM
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
02-28-2001, 04:28 AM
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
02-28-2001, 08:21 AM
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
02-28-2001, 08:39 AM
Thanks Jack that means alot, and yes I will more than likely be visiting alot.

All the best
Jazjam :-)