Check-boxes

Andren

Registered User.
Local time
Today, 07:59
Joined
Sep 3, 2002
Messages
55
Hi all!

I wonder - after having no answers after rerading a lot - How do you use check-boxes as selection criteria for a search - say in the output for a report or a form?

Do I make myself clear?

Thanks.

/ Anders
 
There’s an excellent example in the book:

Beginning Access 97 VBA Programming by Robert Smith & David Sussman. ISBN 1-861000-86-3

The example uses an SQL statement built from If statements depending on which check boxes are selected.


P.S. I looked it up on Amazon and it’s got good reviews and it’s still available and pretty cheap.
 
The Criteria Form is in Chap 7 (See Contents below) and the book includes a CD with the form and code on...

Chapter 7: Manipulating Objects
Creating Queries at Run-time
The Criteria Form
Flexibility
Power at the Desktop
Using SQL
How frmCriteria Works--Building the SQL Statement
Checking the WHERE Clause
Displaying Selected Records at Run-time
Using the Where Clause as a Filter
Modifying a Form's Record Source
QueryDefs
Creating a Table of Matching Records
Implementing the Intermediate Table
The BuildOrderIDTable Function
Building a Table with the DAO Hierarchy
The Ten Steps
Summary
Exercises
 
multiple check boxes for selection

Hi !

I could not find the book.

Is there a chanse that anyone could give me some
illustrative VBA-code for using multiple check-boxes to select reccords in a database.

I have a list of symtoms - and I want users to check/select one or more of those, having a report written based on the combination of checkboxes choosen.

I would be more (!) than tnankful if anyone in the world could help me with rhis problem.

Thanks.

/ Anders
 

Users who are viewing this thread

Back
Top Bottom