No new records in datasheet

[eww]

I'm having a strange problem that may be a little difficult to explain so if you need more information just ask and I'll be happy to try to explain it a little better.

I have a subform in a datasheet view so that the users can list segments/categories for the work they do. these are related to a job number in the main form. For some reason when I go into the sub form and start listing segments, it will only do 1 or 2 and then stop there and won't create any more new records in the subform. The allow additions is turned on and the tab controls appear to be working right so I'm not sure what's the matter. Any ideas?

[ajetrumpet]

you can add TWO new entries and that's all?

how many recs are there before you start adding?

is the main form and sub set to YES for 'allow additions'?

any other forms open?

is the source of the main and sub the same? if they are queries, do they overlap and lock the same datasets?

is anyone else using the database when you are?

is the sub linked on child and parent fields? if they are, is referential integrity enforced? if it is, that might be the issue.

what exactly happens when you try to enter the 3rd record? a beep? can't move to the 3rd at all? error when entering an ID? etc...

what is the relationship between the main and sub?

(these are some of the questions that you might answer to pinpoint the issue)

[eww]

well as I stated previously, Allow Additions is true, and while I said 1 to 2, it appears there's only one new record that is able to add, and sometimes not even that one.

they have their own sources in their own tables. other people are using a front end copy, that's how I first learned about the problem. when you tab through it appears to just tab out of the subform instead of going to a new record.

the relationship is how it is supposed to be and the Linked master and child fields are what they are supposed to be. However I want to focus on this point because I noticed that in the child field / subform field that is related to the main form the Job Number (this is what I'm linking the two by) isn't populating in there. So it appears to me as if it's not relating to that field somehow? I'm not quite sure, as I said it's very strange to me. Also if this were the root problem, why would it stop me from adding new records there?

[ajetrumpet]

it's quite possible that this is an issue with one of the tables' properties, OR a referential integrity problem.

without seeing visuals, I'm not sure how else to help you. what I would do if I were you though is this:

*delete all relationships between the main and sub table in the relay window
*delete all primary keys and 'no duplicate' field properties in the two tables
*close the form and reopen it
*try adding a record in the datasheet again and see if the same thing happens
*if the problem is solved, you've narrowed it down to an issue of either RI or a duplication in a field.

other issues may be 'record locks', 'code', or even 'corruption'. don't rule out the corruption possibility! others here may have more ideas, but that's all i can personally think of..

[eww]

Thanks for the recommendations, I messed with the relationships and noticed that the Job Numbers were populating again so that part is at least fixed.

As far as creating a new record, I noticed that if you left the main form and came back in, or moved records and went back to the same one you were on, that the subform would have a new record option, so I for right now I am kind of cheating with a Refresh on the Main Form from a subform action to get new records to show up. I'll continue to try to resolve the problem though.