subform not saving historical information

  • Thread starter Thread starter Learning Access
  • Start date Start date
L

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?
 
Learning Access said:
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?
Click to expand...

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
 
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.
 
Learning Access said:
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.
Click to expand...

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
 
Back
Top