Import from Excel problem

[RLehrbass]

After importing 31 records from excel to tblMember that contained 2 records already.
I can see all the new records in the table tblMember but when I go to my frmMember, I only can access the original 2.


Any suggestions on what is missing?

[June7]

Any filter criteria applied to the form? Opened the form after import? What is the form's RecordSource? If it is a query, does it include multiple tables with INNER JOIN?

[RLehrbass]

OK, One critical field did not populate that has a join...Filled the row in and WALLA!
Thank You.

[June7]

Why is the form RecordSource a query joining tables, especially INNER JOIN? INNER JOIN requires related records in both tables.

Normally a form can do data entry/edit for only one table.