Enter your email address:

Delivered by FeedBurner

Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?
Home Page








Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!

eXTReMe Tracker

  Thursday, December 17, 2009 – 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.
Base Combo Box on Parameter Query to Filter Values

See all Topics

Labels: , ,

<Doug Klippert@ 3:25 AM

Comments: Post a Comment

  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