subform new records

the subform control was referencing tblClients.ClientNum, i changed it to
ClientNum and its working now. thanks a bunch!


"ruralguy via AccessMonster.com" wrote:

In order for Access to assist in filling in the FK in the SubForm, the two
fields need to be the same type and specified in the LinkChild/MasterFields
properties of the SubForm Control.

Chuck wrote:
bingo! thanks - however i had to add the FK manually to the subform (i'm
using a custom Text based PK/FK). I would like this automated as i have a
text box on the same tab with the PK showing. Suggests?

I'm sorry Chuck but I thought you had a RecordSource for the SubForm. The
RecordSource of the SubForm should be a query of the table you wish to
[quoted text clipped - 13 lines]
record. I have Parent/Child properties of the query coded with [ClienNum].
What have i missed.

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200710/1

Great Chuck. Glad you got it working.

Chuck wrote:
the subform control was referencing tblClients.ClientNum, i changed it to
ClientNum and its working now. thanks a bunch!

In order for Access to assist in filling in the FK in the SubForm, the two
fields need to be the same type and specified in the LinkChild/MasterFields
[quoted text clipped - 9 lines]
record. I have Parent/Child properties of the query coded with [ClienNum].
What have i missed.

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200710/1