Records duplicating through form navigation

[DMWM]

Hi,

I've searched high and low for the answer to this question as it should be
really simple.

My form is showing each record twice!

There is a main form frmJob and Sub Form sfrmProducts_Quoted I tried
creating a button that would repeat the order and it didn't work so i deleted
it now everytime i enter a new job through the form, save, re open the form
shows there to be twice as many records as there are.

Each job is displaying twice and i really cant work out why.

Someone please help me

DMWM

 

[Dirk Goldgar]

Hi,

I've searched high and low for the answer to this question as it should be
really simple.

My form is showing each record twice!

There is a main form frmJob and Sub Form sfrmProducts_Quoted I tried
creating a button that would repeat the order and it didn't work so i
deleted
it now everytime i enter a new job through the form, save, re open the
form
shows there to be twice as many records as there are.

Each job is displaying twice and i really cant work out why.

Is it the main form that is showing duplicate records, or the subform?
Whichever it is, check out the recordsource of the form in question. Maybe
the recordsource is a query (whether a stored query or an SQL statement)
that includes a joined table with multiple records such that it results in
duplicate records being returned.

 

[Jerry Whittle]

The first thing to check is the actual data in the tables. Could there
actually be two records?

Next go to the Relationships window and ensure that the two tables are
joined with Referiential Integrity enabled. If not, nor will it let you, that
could be part of the problems.

If all else fails, I'd create a new form and subform. There might be
somethign from your earlier efforts to duplicate records still working.