Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Updating a field in a Table with a subform field

0 views
Skip to first unread message

linda

unread,
Nov 26, 2009, 12:33:03 PM11/26/09
to
Hi,

I have a form that has a subform. I would like to update the Table that is
bound to my form with the info from the subform once the use is done entering
the info on the main form. Ex. I want the stockcode field in the subform to
update in the stockcode field in the main form's table.

Thank You
Linda

John W. Vinson

unread,
Nov 27, 2009, 12:06:37 AM11/27/09
to
On Thu, 26 Nov 2009 09:33:03 -0800, linda <li...@discussions.microsoft.com>
wrote:

Could you explain WHY?

It appears that either you're storing the stockcode redundantly in two tables,
or you're (for some reason) entering a stockcode on the subform with the
expectation that it will update the main table.

Could you explain your tables structure and relationships, and the
recordsources of the main and subform?
--

John W. Vinson [MVP]

0 new messages