Update record form help

[Bing Li]

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.

 

[kingston via AccessMonster.com]

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.