[ahcould]

I have two combo boxes. When the form loads the db connection opens a recordset that selects all the data from the retaillocations table. When you choose the region (0-4), that number loads into a text box and the Contacts load into the forst combo box. Now I want to select only the Name based on the Contact selected for that particular record, but I cannot for the life of me remember how to do that. This is a VB6 question BTW.

Jim

[Micromax]

Hi,

I think you just want the ContactName. So the properties for the combobox should be like this:
Record Source SELECT ContactID, ContactName FROM tableName ORDER BY ContactName;

Bound Column 1
Column Count 2
Column Width 0",1.5" 0 to hide the first column ContactID.

I hope this helps.

Rob