Multiple ComboBoxes

[KayJen]

I am tracking traffic accidents using a form and several combo boxes, here is my current method:

I have a table with all streets in the city listed, however, some not only have a proper name but they also have a county number and/or state number, which means a police officer might use any of them, I need the street name only for charting purposes:

Table Example:
Proper Name: County No. State Road
Bull Street 1-173 I-277

Using the combobox they start typing "Bu" and Bull Street appears, what I would like to know is there a way to type "1-173" or "I-277" from one combobox and the Street Name fills in the box.

My current system is I have an unbound text box and three adjacent combo boxes if you select State Road and so on the Street Name is filled in. This system is fine, except I have to do this for Collision Street, Base Street and Toward Street, so I have nine combo boxes and 3 unbound text boxes, if possible I would like to have 3 combo boxes.

Thanks,
Sonny

 

[Schof]

The problem is that each combobox can only be bound to one field. This means that it works fine if they enter in the street but not the county # or state road. What I would recommend is adding three radio buttons; one for proper name, one for county #, and one for state road. Have the use select the appropriate radio button before entering in the value in the combobox.

You would need to add code such that whenever one of the radio button values change then you would set the comboboxes bound column appropriately.

For example, if they select the county # radio button then in the radio buttons On_change event you set the comboboxes bound column to '2', etc.

Does this help?