Selecting Duplicate Values in a Combo Box

[Davidekreed]

I have a combo box which selects the suburb names and then automatically fills in state, region, post code etc.

However, there are duplicate suburbs in different states.
Q. When the user enters a suburb name on a form which may be in more than one state, how can I then prompt the user to select the one with the correct state or post code?

Many thanks,
Dave

 

[Travis]

Since you use the Suburb to retreive the other information, make sure the State and Post Code Columns are visible also. If the List is Sorted on Suburb they will all appear together.

 

[Davidekreed]

Yeah thanks Travis, I have done that and it helps the user select the right one. However, for a fast data entry user that might not be myself, I would like him/her to be prompted to make sure a suburb that has duplicates in many states is the right one. This is because when you type in the suburb name, it automatically accepts the firt one on the list when you tab to the next field.

Maybe I'm just being too cautious.

 

[Travis]

You will need to open a recordset using the Suburb name in the combo box as the criteria.

Then Check to see if the recordset has more then one record.