Why can I not view all records in the table in Form view?

G

Guest

I have a form to enter data that gets stored in 4 tables. All the info goes
in, but I can only view 65 records - there is currently 70 in the table. The
form allows me to enter in all data and data goes to each of the tables as it
should - but when I attempt to view all the records in the 'Form' view, it
will only show me 65 of them. Any ideas why I can't see all of them?
 
J

Joseph Meehan

kkeene said:
I have a form to enter data that gets stored in 4 tables. All the
info goes in, but I can only view 65 records - there is currently 70
in the table. The form allows me to enter in all data and data goes
to each of the tables as it should - but when I attempt to view all
the records in the 'Form' view, it will only show me 65 of them. Any
ideas why I can't see all of them?

I suspect it has to do with the joins of the tables.

You say there are 70 records in "the table" How many records are in the
other three tables? Are the joins set up to show all the records from the
table with 70?
 
D

Douglas J. Steele

What's the recordsource of the form? Assuming it's a query, does it show all
of the data?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top