populating linking data from form to subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

IrenaY - 02 Dec 2005 16:33 GMT

I have a master form with three sub-forms (tabular). When I enter data to
the sub-form (generated by frmQry_CommitMoneyCat), I would like the data in
the linking field [Project_ID] that resides in the Master form (generated by
frmqry_ProjName_Commit), to populate the [Project_ID] field in the subform
automatically.

Should I be approaching this on the query level or on the form level?

One of the error messages I'm getting is "The LinkMaster Fields property
setting has produced this error: The Object doesn't contain the Automation
object TBL_Project"

Thanks so much for any of your ideas.

Reply to this Message

Marshall Barton - 05 Dec 2005 04:58 GMT

>I have a master form with three sub-forms (tabular). When I enter data to
>the sub-form (generated by frmQry_CommitMoneyCat), I would like the data in
[quoted text clipped - 7 lines]
>setting has produced this error: The Object doesn't contain the Automation
>object TBL_Project"

Filling in the ID is automatic, once you get the Link
Master/Child properties set correctly.

The Link Master property can be set to either the main
form's record source field name, Project_ID, or the name of
the text box bound to the Project_ID field. Do not try to
include a table name or anything else that might clutter it
up.

The Link Child property need to be set to the subform's
record source field for the ID field. I think you said the
subform field is also named Project_ID, if so use that.
While you can not use the name of a text box for the Link
Child property, you may need to have a text box bound to
that field.

Well that was a bery long winded way of saying that both
properties should be set to Project_ID

Signature

Marsh
MVP [MS Access]

Reply to this Message