By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,738 Members | 1,493 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,738 IT Pros & Developers. It's quick & easy.

? about cascading updates with lookup table changes

P: n/a
(I originally posted this to the data access newsgroup but received no replies)

I've got an Access 2003 mdb that I'm converting to VB.Net. I'm having
trouble with getting the main data source to update after updates to a lookup
table.

There are 2 tables with a one-to-many relationship in the mdb. VB.Net
recognizes this relationship according to it's dataset designer diagram.
Currently I have 2 forms: a main form for data-entry and a form for updates
to a lookup table. Data for this lookup data is in a combobox on the main
form. When I modify one of the items on the lookup form, the data on the
main form does not get updated until I've closed the form and reopened it.
The data in the lookup table gets modified as expected.

I assume I have to update the table adapter for the main
form after saving the changes to the lookup table. I tried the following
code after updating the item on the lookup form (not both lines at the same
time):
Form1.TblPhotosAndImagesTableAdapter.Fill(Me.Photo sAndImagesDataSet.tblPhotosAndImages)
Form1.TblPhotosAndImagesTableAdapter.Update(Me.Pho tosAndImagesDataSet.tblPhotosAndImages)

But the table adapter does not update until I exit the application. How do
I update it immediately upon saving the item on the lookup form? Thanks for
any help or advice.

Nov 28 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.