Link Master/Child Fields in Forms

bmoyer123
Lounger
Posts: 33
Joined: 05 Jan 2017, 16:12

Link Master/Child Fields in Forms

Post by bmoyer123 »

I have a form which allows you to enter data into unbound fields. A program takes this data and adds it to a table in the database. I would like to have a sub form to the original form that shows the data that was added to the table. Since the unbound field is not linked to specific data in form, how do I get the sub-form to only show that data which was entered by a module. I have no problem doing this when form is linked to a specific table or query, but am not able to do that in this case.

User avatar
HansV
Administrator
Posts: 78487
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Link Master/Child Fields in Forms

Post by HansV »

> "to only show that data which was entered by a module"

How can we distinguish the records entered by a module from other records?
Best wishes,
Hans

bmoyer123
Lounger
Posts: 33
Joined: 05 Jan 2017, 16:12

Re: Link Master/Child Fields in Forms

Post by bmoyer123 »

The name of unbound field COLL# is the link between records in table and original form. The field in the sub form (inventory table) is COLL#. The problem is I can't seem to link COLL# (name) since it is not an linked to anything.

User avatar
HansV
Administrator
Posts: 78487
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Link Master/Child Fields in Forms

Post by HansV »

The link wizard won't let you specify a control on an unbound form as Link Master Fields, but you can enter the name in the Link Master Fields and Link Child Fields properties manually.
Best wishes,
Hans