Using wizard to create 'datasheet' form

[David]

I used the wizard to create what it called a
'datasheet' form - but it only included one row on the
form.
Also the form has to be opened in either EDIT or ADD mode
which precludes the other.

This is useless to me as my table has hundreds of rows and
I cant expect my users to page forward a record at a time.
Is there a quick and easy way to create a real datasheet
type form that allows editing or deleting existing
records, and adding new records.

 

[Rick Brandt]

I used the wizard to create what it called a
'datasheet' form - but it only included one row on the
form.
Also the form has to be opened in either EDIT or ADD mode
which precludes the other.

If your form is bound directly to a table that has hundreds of rows then
the form should display hundreds of rows unless you either have a filter
applied or the form's DataEntry property is set to Yes.

In DataEntry mode the form opens with a single blank row for entering a new
record. When a new record is started another new row appears beneath the
current row for the next new record and so on.

In EDIT mode you have access to all existing rows for editing AND you also
have a blank row at the bottom for entering new ones.

 

[David]

It seems the wizard calls what I wanted a 'tabular' form.
I find that very confusing.