>>>>
>>>>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.
>
>Again, unless I want to take what I'm getting from the Patient Browse form, reformat it and then seek it in the cursor - there is absolutely NO relationship between the two.
>
>All I want is to be able to take the value I'm getting to the combobox and have the combobox tell me whether that item exists with it's List or not, and if so - go to that item in the list
Try to set the value to non-existant value in the list - the DisplayValue is going to be blank. This is how you can determine if the value in the list or not.
If the item exists, setting value of the combobox to the correct value is enough to re-position the combobox to the correct record in its source.
If it's not broken, fix it until it is.
My Blog