Problem w/Sub Form

  • Thread starter Thread starter lancer
  • Start date Start date
L

lancer

Thanks in advance for your help.

I have a form that with tabs on it. On one of the tabs I have a sub form.
They're linked by employee id. When I set a value on a sub form and close
the parent the next time I go to the parent record the sub values aren't
there. If I right click on the parent form and select sort the child values
suddenly appear. If I open the parent and select a value that previously
selected I get a keying violation.

Looking forward to your response.

thanks
 
We need a bit more information, but if the value you set on the sub-form
is the Employee_ID, it "disappears" because it is no longer related to
the same parent record - it is related to a different one (if indeed it
is related to any parent record at all; check your referential integrity)

If it's not the EmployeeID data you are changing - are the Master -
Child links correctly set?
suddenly appear. If I open the parent and select a value that previously
selected I get a keying violation.
Click to expand...

What do you mean by "select" - entering data? And what is the error
message you are getting?

John
 
Back
Top