Forms with multiple entries to one table

Hi, I am trying to create a form that will create multiple entries on one
day. For instance, we receive 3 different types of inventory in one day. I
want to create a form for each day where you can enter each of the 3
different inventory types for that day. Then each inventory type should
create a separate record in the table.

I tried putting the same label multiple times but when I enter the
information in the first box, it just adds it into the other boxes.

Any help is appreciated.

On Wed, 03 Dec 2008 19:11:00 -0800, OscarCat wrote:

Hi, I am trying to create a form that will create multiple entries on
one day. For instance, we receive 3 different types of inventory in one
day. I want to create a form for each day where you can enter each of
the 3 different inventory types for that day. Then each inventory type
should create a separate record in the table.

I tried putting the same label multiple times but when I enter the
information in the first box, it just adds it into the other boxes.

Any help is appreciated.

Open your form in Design view an look at its structure. You will see a
section named "Details". That is likely where you have placed your
controls.

In a bound form one instance of the detail section equals one row
(record) in the table the form is bound to. You enter a record and then
navigate to a different record in the form and now you have a new detail
section in which you enter a second record etc..

If you want to enter (and see) more than one record at a time then you
need a continuous form. With those you see as many existing records as
the height of the window allows for plus you can scroll to see more.

To do what you are describing you would need to use an unbound form and
then create all your records via code or macros.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com