CODEWITHSUNDEEP
ms-accessmultiple-columnsdatasheet
Daniel
Daniel

Reputation: 73

MS Access Datasheet view

I have created a subform in Access that contains a combo box and multiple textboxes. I can view this form as a datasheet view and see a single line containing all the fields that I wish to have, but cannot add any more lines after this information.

Can anyone tell me how to make this datasheet show multiple lines?

Here is an image of the subform in both design and datasheet view:

Datasheet View Datasheet View




Design View Design View

Upvotes: 0

Views: 951

Answers (2)

cecopes
cecopes

Reputation: 85

Do not use datasheet view if you want to use multiple lines. Use Multiple Items form type. You can manually create any number of rows.

Upvotes: 1

parakmiakos
parakmiakos

Reputation: 3020

The datasheet view of a form corresponds to a recordset. Assigning a table or a query to the form's recordsource will cause the datasheet view to show one line per record.

The design view is used to modify and customize the form view of the form. For the datasheet one, you can merely add / remove which fields of the underlying recordset you wish to display, and change the controls' bound sources, etc.

Upvotes: 0

Related Questions