easy question on forms/tables

[kaosyeti]

it may be because i'm having a BAD day but i can't come up with an easy way
to do this...
i want to have a form for recording one department's yearly forecasted data.
what i have is a column of months, to the right of which i have two text
boxes for entering units and gross. the thing is the only way i could think
of to get this into a table was to have a table with a field for each
separate text box. so i have:

form:

Month Units Gross
January ___________ ___________
February ___________ ___________
etc...

for a table that has fields defined as:

janunits number
jangross currency
febunits number
febgross currency
etc...

when what i want is a table with these fields:

month text
units number
gross currency

i've only ever worked with forms where the control source of each box is a
single field in a table. i KNOW there must be a way to do this because it's
so simple. i'm just out of it today. thanks for looking.

--
Greg

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200602/1

[Rick Brandt]

kaosyeti<[at]>comcast<[dot]>net via AccessMonster.com wrote:

it may be because i'm having a BAD day but i can't come up with an
easy way to do this...
i want to have a form for recording one department's yearly
forecasted data. what i have is a column of months, to the right of
which i have two text boxes for entering units and gross. the thing
is the only way i could think of to get this into a table was to have
a table with a field for each separate text box. so i have:

form:

Month Units Gross
January ___________ ___________
February ___________ ___________
etc...

for a table that has fields defined as:

janunits number
jangross currency
febunits number
febgross currency
etc...

when what i want is a table with these fields:

month text
units number
gross currency

i've only ever worked with forms where the control source of each box
is a single field in a table. i KNOW there must be a way to do this
because it's so simple. i'm just out of it today. thanks for
looking.

Use a continous form with a record per month...

ComboBox TextBox TextBox
for Month for Units for Gross
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[kaosyeti]

ah-ha. never heard of continuous forms before... is there any way for it to
automatically select the 12 months in the combo box upon opening the form so
that 12 records are showing and the combo box has the months pre-filled for
the user? not exactly necessary but you don't know how SIMPLE this has to be
for the end users that i have in mind at my company. some are just plain sad.
...8)

Rick Brandt wrote:

it may be because i'm having a BAD day but i can't come up with an
easy way to do this...

[quoted text clipped - 29 lines]

because it's so simple. i'm just out of it today. thanks for
looking.

Use a continous form with a record per month...

ComboBox TextBox TextBox
for Month for Units for Gross

--
Greg

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200602/1