Unable to update one form when it is filtered based on another

[Jennifer Cali]

Hello,
I have two forms: frmContacts and frmChildren. In frmContacts the primary
key is atnContacts, and it is tied (via one to many relationship) to
ingzContactLink in the frmChildren.
So...my problem is that not all my friends have kids...yet. I have a button
in frmContacts that opens frmChildren, and I have it set to filter the
records based on a relationship (created within the button action item)
between atnContacts and ingzContactLink. When I click on the button it opens
up frmChildren but it isn't letting me add any new records. Also, it isn't
recognizing that it is tied to frmContacts. How can I make this work?
My desired situation is that I can click on the button in frmContacts and it
will open up a single record in frmChildren that will be blank if no data
exists or have info in it that was added at an earlier time.

Thanks for your help!!!

 

[John Vinson]

Hello,
I have two forms: frmContacts and frmChildren. In frmContacts the primary
key is atnContacts, and it is tied (via one to many relationship) to
ingzContactLink in the frmChildren.
So...my problem is that not all my friends have kids...yet. I have a button
in frmContacts that opens frmChildren, and I have it set to filter the
records based on a relationship (created within the button action item)
between atnContacts and ingzContactLink. When I click on the button it opens
up frmChildren but it isn't letting me add any new records. Also, it isn't
recognizing that it is tied to frmContacts. How can I make this work?
My desired situation is that I can click on the button in frmContacts and it
will open up a single record in frmChildren that will be blank if no data
exists or have info in it that was added at an earlier time.

Thanks for your help!!!

I'd REALLY suggest making frmChildren a Subform of frmContacts, using
atnContacts as the Master Link Field and ingzContactLink as the Child
Link Field. This will - without any code or hassles at all -
automatically keep the two forms in synch, and let you add children
with the ID field being filled in automatically.

If the form is too crowded for a subform, you can put a two-page Tab
Control on the form; put all your contact controls on the first page,
and the subform on the second.

John W. Vinson[MVP]