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?
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!