Link Master/Child Fields in Forms
-
- Lounger
- Posts: 33
- Joined: 05 Jan 2017, 16:12
Link Master/Child Fields in Forms
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.
-
- Administrator
- Posts: 78487
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Link Master/Child Fields in Forms
> "to only show that data which was entered by a module"
How can we distinguish the records entered by a module from other records?
How can we distinguish the records entered by a module from other records?
Best wishes,
Hans
Hans
-
- Lounger
- Posts: 33
- Joined: 05 Jan 2017, 16:12
Re: Link Master/Child Fields in Forms
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.
-
- Administrator
- Posts: 78487
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Link Master/Child Fields in Forms
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
Hans