Results 1 to 1 of 1
2006-03-06, 09:27 #1
- Join Date
- Jan 2001
- Nottingham, UK, Nottinghamshire, England
- Thanked 0 Times in 0 Posts
HFlexGrid not updating (Win2000 Office 2000 VB6)
Hi. I'm having trouble getting a Hierarchical FlexGrid to update what it shows when the underlying data is updated.
I show a HFlexGrid on a form (using just as datagrid - getting data from a dataenvironment, de1, and a command, qCommand say). Clicking on a row brings up another form allowing (amongst other things) the user to delete the row data, ie table entry. So I code:
Essentially, after deleting the entry in the table, I requery the command qCommand. So the data should be updated, no?
The Activate event of the first form, which is then returned to, states:
If .State Then .Close
Set .DataSource = de1
.DataMember = "qCommand"
Yes, I know, I'm requerying again - been requerying everywhere! Even with all that, the HFlexGrid does NOT update to show that the data has been deleted. I have to end the whole application, restart it and show the first form again before the HFlexGrid shows without the deleted data.
What am I doing wrong - or not doing right?