Multiple records at once

[Entellex]

How does one get multiple records inserted into a table at once, when you press the "Add Record" button? Resulting in the table below:

MAKE	MODEL	GAS / ELECTRIC	COUNT	YES / NO
Honda	Accord	Electric	1	YES
Honda	Accord	Gas	3	YES
Honda	Civic	Gas	0	NO
Ford	Mustang	Gas	4	YES

This is how it must be setup, all I need is to know how.

[JeffChr]

Where is the data coming from ?

[Entellex]

MAKE/MODEL/GAS/ELECTRIC will either come from another table or a drop down, which ever one I can get to work.

Count/YES/NO will be inputted

-

Trying to avoid having to type one in and then press ADD 1 by 1

Instead be able to fill out the whole form with drop downs and inputs, then press ADD, and it adds those multiple lines.

[JeffChr]

You shouldn't have to click any buttons to add rows to a table. Are you sure you're not designing a table? There is a button labeled "Click to Add" when you first open a blank database. Once your table is designed, open it and you will be able to add row data very easily-even paste it from somewhere else like Excel.

[Entellex]

I am talking about from within a form.

[JeffChr]

I don't think there is a simple answer to your question then. The form is bound to a data source. You can determine if the data source is a query or a table by looking at the properties of the form in design view. If the form is bound to a table or a saved select query then you could edit the data directly without using the form. Forms can also do things in the "background", such as calculations which may be important to the structure of the database.