 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / November 2006Update record form help
Hi, I have a main Form (FormA) which is bounded to TableA. FormA contains a tree view and a subform (FormB) which is bounded to TableB The tree view contains a list of products organised in different categories. When the user select a product from the treeview, the productID of the selected product is passed into FormB and user can then enter a product description in at text field in formB, then ProductID and ProductDiscription are saved in TableB. When the user select a different product, I need to refresh the form so it creates a new record in TableB with ProuductID equal to the new productID and the ProductDescription field refreshed to empty. When the user then select the previous product, the form shows what user has entered before. What is the best way to achieve this? Could anyone please help me? Thank you. If FormB is a true subform that is linked via ProductID to FormA, then any new records in FormB will automatically contain the ProductID from FormA. It won't create a new record unless the user wishes to do so by entering data. Similarly, if a new record is created in FormA, FormB will be blank. Are the Link Child/Master Fields properly set in the subform? Does FormB allow data edits and record additions? Go into FormB's properties window to find out. >Hi, >I have a main Form (FormA) which is bounded to TableA. FormA contains a tree [quoted text clipped - 12 lines] > >Thank you. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.