UPDATE. Not sure if I've just had an Epiphany on this, but if I just add an event to the child Binding source - as below, then that seems to do the job?
Not fully checked it through, but seems to work 100%, and obviously needs some tidying up/error handling...
Private Sub...
Thanks for the feedback - appreciate I have 2 minds on this with far more knowledge than mine. ;)
John: I will work through your comments with Beth Massi's code, and hopefully all will be well.
JMC: Have fixed the 2 bugs that had been thrown up, and understand your comments. As far as I can...
Thanks John - I had already looked at another of Beth Massi's posts, but alas - maybe my lack of coding expertise in this area - her solution to the problem missed a key point (she claimed that if the relationships were set up, then the cascade option automatically populated the FK values and...
Thanks - a couple of issues...
Thanks - had seen a few of your posts, and wish I'd found the above a week ago!
Trying to match the logic to my particular scenario, and whilst it was going well - I have run into 2 issues.
1. Dim lastAutoNumber =...
Hope someone can help / point me in the right direction, as I have been looking this up for some while, and am stumped.
I have VB 2010 accessing Access via the normal OLEDB connection (project data source). A Form containing MASTER/DETAIL Records - created by making a dataset from both tables...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.