Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal









Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com


  Monday, April 21, 2008 – Permalink –

Cascading Combo Boxes

Everything's connected



"Cascading combo boxes are used to help aid the user in determining a choice when entering data into a form.

They help to breakdown the options available into selectable sub-groups such a State & City, Product Type & Product, Department & Employees.

The user can select, for example, Customer Services in a combo box and the second combo box's list will reflect this selection and only list those employees within Customer Services.

Switch to Finance and all the Finance employees become selectable, etc."



A cascading combo box solution:

Roger J. Carlson

CascadingComboBoxes.mdb (beginner)
CascadingComboInSubform.mdb (intermediate)



See all Topics

Labels: ,


<Doug Klippert@ 6:16 AM

Comments: Post a Comment

  Sunday, December 17, 2006 – Permalink –

Combo Box Queries

How to



Parameter queries add flexibility to filtering records in a database. To make it easy, take a look at this approach from Martin Green's Office Tips site:

Drop down box in a Parameter Query

  1. Build a dialog box with as many combo boxes as you need.
  2. Design a query to read its criteria from the information on the dialog box.
  3. Create a macro or visual basic procedure to tell them both what to do.


Also
Base Combo Box on Parameter Query to Filter Values



See all Topics

Labels: ,


<Doug Klippert@ 5:23 AM

Comments: Post a Comment