>>>>I've got a Combo Box that has a list of names. The users want to also be able to pick a name from a browse form - ok, not a problem. I can set the DisplayValue so that the name selected shows in the closed combobox, but I also need to 'set' the ComboBox index so I can get other information that corresponds to that name.
>>>>
>>>>Which property do I use?
>>>
>>>If you get names from the table, then bind combobox.value to table.id and then use Combo.Value to search in the table.
>>
>>Nope, that's not how it works. They want to be able to either use the combobox to select a name (which is pulled from a different table via SQL and loaded into the combobox) or they want to select the name from an existing Patient browse form and have that display in the closed combobox.
>>
>>The patient browse works - I load the name selected into the cbo.DisplayValue. I need to get the combobox 'set' to that DisplayValue, so I can know if 1) the name selected is in the Combobox list or 2) the corresponding information out of the other table that's already in the combobox list.
>
>What is the RowSource for the combo? If this is a cursor, you get the info from the cursor directly, since it should be sitting on the right record.
The Browse table and the Combobox table are not related. The Browse table is gotten to via a button.
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place