469,586 Members | 2,160 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,586 developers. It's quick & easy.

? about cascading updates with lookup table changes

(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

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
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
0 1129

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Next | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.