Subform datasheet - adding records

[David]

Using Access 2002, I have a subform that defaults to datasheet view.
To add a record, you have to tab through the last field. Each record
shows on separately. I want it to show all of the records on one page
and the empty new record shows at the bottom of the page. What do I
need to set to make this happen?

Thanks,

David

 

[kingston via AccessMonster.com]

Open the subform by itself in design mode. Does the form have Navigation
Buttons set to Yes? This will include the add record button at the bottom of
the form (even as a subform). You might not be able to fit all the records
on one page because of the number of records, but a new empty record should
be at the bottom of the list if the form's Allow Additions property is set to
Yes.

 

[David]

Thanks for the reply. Allow Additions is set to yes. I've tried
Navigation Buttons Yes and No, same thing both ways.

 

[kingston via AccessMonster.com]

Is the subform being cut off in the main form? Open the subform
independently. Does it behave the way you want/expect it to? If not, the
subform needs to be redesigned. If it does, then the problem is in the way
the subform has been embedded in the main form.

Thanks for the reply. Allow Additions is set to yes. I've tried
Navigation Buttons Yes and No, same thing both ways.

Open the subform by itself in design mode. Does the form have Navigation
Buttons set to Yes? This will include the add record button at the bottom of

[quoted text clipped - 16 lines]