Form only allows five records

[Nancy]

The form and subform are based off two seperate tables. The record source
for the form is a query of the two tables using the query builder under the
properties of the form. When in form view, the form will not advance past
five records. I can add info into the form and subform and it will save to
the tables, I can advance to a new record to add new infor and it will save
to the records, etc but it will not let me add past five records. The
Master/Child field is POID and the allow additions is clicked to yes. Any
other ideas?

Thanks you

 

[Golfinray]

You didn't by any chance check top 5 records on your query properties? Also
check the form properties for CycleAllRecords and make sure it is set to yes.

 

[Jeff Boyce]

Nancy

You posted in a tablesdbdesign newsgroup, but mentioned a form. If the form
is preventing you from adding more than five records, maybe there's code
behind the form that prevents you from adding more than five records.

I'm not aware of a table-level setting/constraint that would do this (hmmm,
now that I think about it, I believe one of the responders in the newsgroup
here has discussed setting table-level constraints via data definition code
.... if this is the case in your situation, I'm not sure how you'd "discover"
that!).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[boblarson]

Nancy:

I'm going to throw out another possibility, which I've found is very common.
It sounds like you might have created relationships from an Autonumber to an
Autonumber which can have this effect.

For example, if your first table is the main form and then you have a
subform with the second table, then you create 5 records and in one of the
records you have created 2 records in the subform, then the autonumber on the
second form will now be at 7 but the autonumber in the main form is set at 6.
They do not match and therefore you can't add another record.

Make sure that your relationships are set properly. The autonumber in Table
A (Primary Key) should be a Long Integer in Table B (foreign Key).

So, that MIGHT be your problem.
--
Bob Larson
Access World Forums Super Moderator

Tutorials at http://www.btabdevelopment.com

__________________________________