F
flipper1067 via AccessMonster.com
I have a form that has a FK in it but it isn't populating. When I go into
frmApplication and click in children subform on the command button ""Answer
Child Questions". It opens another form that I try to put in a response to
the first question. It won't let you move on to the next question because
there is no value for ChildID. I could type the ChildID in, but of course, I
want them to autopopulate instead. I tried to put in the following in the
default value for the ChildID text box in frmChildQResponses: [Forms]!
[frmApplication]![sfmChildren].[Form].[ChildID]
Can anyone help me link these two forms or figure out what I am doing wrong?
Thanks.
frmApplication and click in children subform on the command button ""Answer
Child Questions". It opens another form that I try to put in a response to
the first question. It won't let you move on to the next question because
there is no value for ChildID. I could type the ChildID in, but of course, I
want them to autopopulate instead. I tried to put in the following in the
default value for the ChildID text box in frmChildQResponses: [Forms]!
[frmApplication]![sfmChildren].[Form].[ChildID]
Can anyone help me link these two forms or figure out what I am doing wrong?
Thanks.