subform not saving historical information

[Learning Access]

I have a subform working within a form to capture employee historical
information such as every years performance rating...however, when I go into
the form to add a new record, it updates the subform with the new record but
does not save the history in the subform...what am I doing wrong?

 

[Keith Wilby]

I have a subform working within a form to capture employee historical
information such as every years performance rating...however, when I go
into
the form to add a new record, it updates the subform with the new record
but
does not save the history in the subform...what am I doing wrong?

It sounds like there is no relationship between the main form and its sub.
Have a look in the parent/child data properties, there should be the primary
and foreign key names in there.

Keith.
www.keithwilby.co.uk

 

[Learning Access]

Thank you, I don't see that I can make a relationship for the Main form and
the sub form in Relationships. Where do I look for the parent/child data
properties, would this be under the PROPERTIES? I am very new to Access.

 

[Keith Wilby]

Thank you, I don't see that I can make a relationship for the Main form
and
the sub form in Relationships. Where do I look for the parent/child data
properties, would this be under the PROPERTIES? I am very new to Access.

Open the form in design view. Show the properties palette and choose the
Data tab, then select the subform object. In the Link Child and Link Master
Field properties should be the names of the primary and foreign key fields,
in other words, data elements that are common to both sides of the
one-to-many.

Keith.
www.keithwilby.co.uk