Main \ Sub Form Data

I have a Main Form that is based on a Table I have named Personnel. I have a
SubForm that is based on the Authorizations Table. The Two Tables are linked
using the field WMWMNum which is the same type in both Tables. The SubForm is
inserted into the Main Form.

The problem is that when I enter data in the SubForm, it initially displays
correctly and does not affect the data in the Main Form. Then, after closing
the form and reopening it, the Main Form will begin to display a duplicate
record for each entry that has been entered in the SubForm. Each of these
entries on the Main Form show up as a record when scrolling through the
records. The record count is increased accordingly on the form only. When I
look in the DataSheet View the duplicates are not there. The only way I have
been able to get rid of them is to delete the record but then the problem
repeats itself. I have tested it on multiple records with the same result.
Any ideas would be appreciated.
Mike

On Sun, 18 Oct 2009 18:44:01 -0700, NelsoMik
wrote:

I have a Main Form that is based on a Table I have named Personnel. I have a
SubForm that is based on the Authorizations Table. The Two Tables are linked
using the field WMWMNum which is the same type in both Tables. The SubForm is
inserted into the Main Form.

The problem is that when I enter data in the SubForm, it initially displays
correctly and does not affect the data in the Main Form. Then, after closing
the form and reopening it, the Main Form will begin to display a duplicate
record for each entry that has been entered in the SubForm. Each of these
entries on the Main Form show up as a record when scrolling through the
records. The record count is increased accordingly on the form only. When I
look in the DataSheet View the duplicates are not there. The only way I have
been able to get rid of them is to delete the record but then the problem
repeats itself. I have tested it on multiple records with the same result.
Any ideas would be appreciated.
Mike

Sounds like the mainform is based - not on the Personnel table - but on a
Query joining the personnel table to the Authorizations table. It shouldn't
be! Open the main form in design view and view its Properties; on the Data tab
the first tab is "Recordsource". What's in it?

It *should* be either just the Personnel table, or a query selecting the
desired records from the Personnel table. It should NOT include the other
table.
--

John W. Vinson [MVP]