2 combos to pick from same set of records?

[Milothicus]

on a form, i'd like to be able to choose a record (and auto populate the rest of the form) by either project name or enquiry number. i can put in a combo box for one and have it fill in the other, as long as it's a text box. if they're both combos that search for records, i can use either one, but they won't auto populate each other.

is it possible to have one combo box choose a value for another combo box?

 

[ColinEssex]

There is an excellent search example that uses multiple fields in the Sample Database section.

Col