Copied from Microsoft Answers:
I imported contacts from an Excel spreadsheet into my table.

When I opened the form that feeds from that table, I see all my past contacts (previous to today) but none of the contacts I just imported.

I went back to the properties sheet in the form's design and double-checked to make sure it was still pulling from the same source, and apparently it is.

Is there any reason that I can see all my new contacts on the table itself - but not in the form I use to modify that table? Do I need to erase the contacts from the table and attempt import again?

I've since noticed that the contacts I enter on my form do show up on the table - but after that they don't re-show on the form. It's like the form is hiding my data so I have to go to another place to find it.

Asked:
Check your form's Data Entry property. If it's set to Yes, the form will let you enter new records but will not show existing ones. Set it to No to display old records as well.
If that's not it, please post the form's Recordsource property.


Answered:

Thanks. I'm in form's design view; property sheet; reading from tab: data. Form's Data Entry property says No. Record Source says All (the name of my table). Update: I tried to create a new form and the same issue is happening. Old contacts there, new contacts not. Haven't changed anything on the table since last working with it. Data entry on this form also says no.



Asked: How did you import the contacts today?


Answered: Right-clicked the table (All), Import, Excel, Append a copy of the records to the table (All), ok, data has headings, finish.

It completed and gave me no error messages.

I'm particularly perplexed now knowing that contacts I've manually entered one-by-one into the form have appeared on the table but don't appear on the form anywhere after that.

Confused!!


I have attached a copy of my database to this thread. Please don't laugh when you see it; it's highly simplistic. :o

Okay, this is strange. I see 903 records in the table and I see 903 records in the form and they are all there and it looks like it is working correctly.

So, the question is - why can't you see them but I can?

Hi. My name is April. And I'm a moron.

:o

I was looking at the ID (which is just the number of the records). Obviously, as I've deleted records, the ID number has continued to rise.

I should have been looking at the number of contacts total at the end of the table.

There's nothing wrong with my database. (I suppose I'm not a *complete* moron, then, since I built the thing and it's operating.)

But yeah. My blonde hair over-rode my brain. I thank you a *ton* for assisting me with my question. :D

No worries - I think most of us have had something like that happen to us at one time or another. :)