>>>>>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.
I mean here the cursor that is used for combobox's RowSource.
If it's not broken, fix it until it is.
My Blog