adding data to subforms

I have a main form and 2 sub forms, linked in a one to many relationship. The
main form is based on a table, I use VB to filter the records when the form
first opens. Everything is fine till I try to add new records. Access wount
let you add records in related tables until there is a matching record in the
"one" side of the relationship. Makes sense to me. So when you are clicking
on the record selector (or using the scroll mouse) and you get to the last
record, you automatically go into "ADD" more on the main form and the related
subforms go blank. Hoe do I keep those open and ready for input?

Try adding a new record in the main form. You should then be able to enter
data in the sub forms.

"danboy" wrote:

I have a main form and 2 sub forms, linked in a one to many relationship. The
main form is based on a table, I use VB to filter the records when the form
first opens. Everything is fine till I try to add new records. Access wount
let you add records in related tables until there is a matching record in the
"one" side of the relationship. Makes sense to me. So when you are clicking
on the record selector (or using the scroll mouse) and you get to the last
record, you automatically go into "ADD" more on the main form and the related
subforms go blank. Hoe do I keep those open and ready for input?