Linking combo box

[Stuart]

Good morning,

I have a combo box [cmbJobType], that gets its values from
a text box [txtjobtype]. If the user picks a value from
[cmbJobType] how do I open up the related record with the
same value in the [txtJobType]. Both boxes are on the
same form.

Thank you, Stuart

 

[Roger Carlson]

This is called the Cascading Combobox problem. On my website (see sig
below) is a small sample database called "CascadingComboboxes.mdb" (oddly
enough), which illustrates how to do this.