Sync 2 Combo-Boxes

[Charles L. Phillips]

Hello,
I am using MS-Access 97.
I have two (2) fields:

1. Courier
2. Tracking Number

1 is to be a combo-box, with selections:
Fed Ex
UPS
USPS
Other
2 is the respective tracking number.

When I make a selection from 1, how do I get 1 to pull up 2, with the
correct the tracking number, & the right prefix, for each courier???

 

[Ken Snell [MVP]]

See The ACCESS Web for a way to link combo boxes such that the second one is
filtered based on the selection made in the first one.
http://www.mvps.org/access/forms/frm0028.htm.

 

[Charles L. Phillips]

Hello,
Exactly what I needed to know...
"Thanks"...