Datasheet View vs. Table View

[pwicr]

I seem to have 11115 records when I go into datasheet view of my form and yet there should only be 9230 according to the main table. Seems some of my records have been duplicated but only in the datasheet view. I don't understand how/why it did that and how to fix.

 

[John Big Booty]

Are you using a query to populate your form?

 

[pwicr]

yes. the control source property of the form does link to a query

 

[John Big Booty]

In that case you are going to need to examine, the structure of your tables, and also the structure and logic of your query.

 

[pwicr]

sigh.

i'm working on it. i'm working with a database that was incorrectly set up so we have to continue working in it until i get the new one set up. This is a really frustrating one.

I will welcome any hints to look for.

Thanks John.

 

[John Big Booty]

Good luck with that

 

[pwicr]

All is well.
ID10T error.

Thanks again.

 

[John Big Booty]

Happens to us all from time to time