Sunday, 14 February 2010

CascadingComboBoxes.mdb (beginner)

This form illustrates how to restrict the value of one combo box based on the value of another. In this case, you choose the city, and you get a listing of just the zip codes available for that city.


It also shows how to get the asterisk (*) to show up in the RecordSource for the city, so you can choose all cities. When you choose the asterisk to list all zipcodes and then choose a zip, the corresponding City appears in the city control.

Download

Access 97 (42 KB): CascadingComboBoxes97.zip

Access 2000 (95 KB): CascadingComboBoxes2k.zip
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Receipt Management: Stop Losing Paper Receipts Forever

Paper receipts fade, tear, and get lost. Here's how the Petty Cash app solves the receipt problem permanently. The Paper Problem Therma...

  • AppendValuesToExcel.mdb (intermediate)
    This sample demonstrates how to append data from a database to an Excel Spreadsheet using Office Automation to find the next empty row in th...
  • Microsoft Office Access 2007
    Microsoft Office Access , previously known as Microsoft Access , is a relational database management system from Microsoft that combines t...