cannot view all records in form view

[jkenn1008]

Hi

I have 4 tables and around 440 records but can only view up to 417 in the form I have designed. I have been adding new records via form and it has been added to my main table, but when i try to view it in form view - the record is not available to view. What do I need to do to correct this problem?

I have checked that there are no filters, data entry is set to No, Auto deletions, additions and edits are set to yes.

Also to mention it seems that the problem has arisen since I set up some new queries, there is a one to one relationship between the tables!

Please help, Thank you

 

[maxmangion]

Is your form based on a query or directly to one of the tables? As regards the one to one relationship, do you have such a relationship between all four tables? I am asking you this question because one to one relationship are not so commonly used so you might have a problem with the design of your tables.

Posting your tables schema can help establishing if your design is correct.