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?
Subscribe to our Windows Secrets Newsletter - It's Free!
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!