Sub-form losing sync

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a sub-form which is linked to a main form via a linked field (which is
a primary key).

The link works well, and when I filter the main form the sub-form
automatically picks up on the filter. This is all great until I make a change
on the sub-form and save it. At which time it loses sync with the main form.
I can then cycle through the records on the main form and the sub-form stays
stuck on the record I was editing.

Does anyone have any suggestions.?

Thanks
Lewis
 
I have a sub-form which is linked to a main form via a linked field (which
is a primary key).
Are you talking about the primary key of the main form data source table?
What field are you using from the table used for the subform data source?
 
KARL DEWEY said:
is a primary key).
Are you talking about the primary key of the main form data source table?
What field are you using from the table used for the subform data source?
First have to mention that I am working on a database that someone else
originally designed!

Right, the main form has a table called [Personal Details] as its data
source. The sub form has a table called [Contract Details] as its data
source. They both share a field called [Personal ID], and it is that field
that I am using as the link criteria between the forms.

I can filter the contents of the main form, which then limits the records
returned in the subform. The problem is that when I edit a record in the
subform, and then move to another record in the main form, they lose sync.

Regards
Lewis
 
They both share a field called [Personal ID], and it is that field that I
am using as the link criteria between the forms.
The word 'criteria' is throwing me. form/subform would not use criteria but
would have Master/Child links.
Open your form in design view and click on menu VIEW - Properties. Then
click on the very top left corner of the subform (on the edge, not the little
square box) and the outter edge should be highlighted for sizing. If you
miss, then click in the main form and then try again. The third and fourth
properties will be the Child and Master links.

--
KARL DEWEY
Build a little - Test a little


Lewis Brunton said:
KARL DEWEY said:
is a primary key).
Are you talking about the primary key of the main form data source table?
What field are you using from the table used for the subform data source?
First have to mention that I am working on a database that someone else
originally designed!

Right, the main form has a table called [Personal Details] as its data
source. The sub form has a table called [Contract Details] as its data
source. They both share a field called [Personal ID], and it is that field
that I am using as the link criteria between the forms.

I can filter the contents of the main form, which then limits the records
returned in the subform. The problem is that when I edit a record in the
subform, and then move to another record in the main form, they lose sync.

Regards
Lewis
 
Hi Karl,

right sorry for the confusion, but yes I have Master/Child links setup -
re-writing the sentance you highlighted previously: "They both share a field
called [Personal ID], and it is that field that I am using as the Master /
Child link between the forms."

Hopefully that should make more sense.
Thanks
Lewis

KARL DEWEY said:
They both share a field called [Personal ID], and it is that field that I
am using as the link criteria between the forms.
The word 'criteria' is throwing me. form/subform would not use criteria but
would have Master/Child links.
Open your form in design view and click on menu VIEW - Properties. Then
click on the very top left corner of the subform (on the edge, not the little
square box) and the outter edge should be highlighted for sizing. If you
miss, then click in the main form and then try again. The third and fourth
properties will be the Child and Master links.

--
KARL DEWEY
Build a little - Test a little


Lewis Brunton said:
KARL DEWEY said:
I have a sub-form which is linked to a main form via a linked field (which
is a primary key).
Are you talking about the primary key of the main form data source table?
What field are you using from the table used for the subform data source?
First have to mention that I am working on a database that someone else
originally designed!

Right, the main form has a table called [Personal Details] as its data
source. The sub form has a table called [Contract Details] as its data
source. They both share a field called [Personal ID], and it is that field
that I am using as the link criteria between the forms.

I can filter the contents of the main form, which then limits the records
returned in the subform. The problem is that when I edit a record in the
subform, and then move to another record in the main form, they lose sync.

Regards
Lewis
 
Back
Top