TabControl ComboBox Lookup Refresh

[Mike Quinn]

I've been fighting an issue for about a day now. I didn't see mention
of it so I thought I'd post it.

I had a Combobox to perform data lookups. The record data was being
populated by a strongly typed dataset. I had the lookup data within
the same STD. The structure was like the following:

STD
Record Data Table:
ID
LookupID
DataField1
DataField2

Lookup Data Table:
LookupID
Description

The STD, as stated above, was being populated with both the record
data and the lookup data. The front end combobox was set up to hook
the LookupID from the Record Data with the description from the Lookup
Data. Standard stuff.

The problem was that the combobox would get set to the first record
from the Lookup Data Table until the user navigated the datagrid.

The issue behind the problem was that the Record Data was being
populated within the STD prior to the Lookup Data being populated.
So, the front end events were firing off to hook the lookup data prior
to the lookup data table being filled.

To fix this, I brought my lookup data into a separate STD and filled
it prior to the record data being populated.

Thanx,
-q

 

[Scot Rose [MSFT]]

Do you have a small sample (preferably with the Northwind database) that reproduces the problem. If so send it to me and I will take a look at it..

Want to know more? Check out the MSDN Library at http://msdn.microsoft.com or the Microsoft Knowledge Base at http://support.microsoft.com

Scot Rose, MCSD
Microsoft Visual Basic Developer Support
Email : (e-mail address removed) <Remove word online. from address>

This posting is provided “AS IS”, with no warranties, and confers no rights.




--------------------