Editing multiple Records

[Shiner452]

I have a continuous form bound to a query. The form has a header tha
specifies criteria for the query and then displays all the records i
the detail section. Each record includes 5 fields...Item, StockNumber
ReadyWeek, PotWeek, and Quantity. The records are displayed in rows.
I would like to place a check box at the end of the row. When th
check box is checked 5 new txt boxes will appear on the right side o
the check box so that it is one long row. I would like these tex
boxes to edit information into a new record on the query. However,
want the information displayed on the left side of the check box t
continue to be displayed. What I am trying to do is this...

I have a greenhouse company and this form is used to schedule th
growing of plants...if we grew 100 herbs in week 14 last year and w
decide to grow 120 herbs in week 14 this year I would like to check th
checkbox next to the record that says we grew 100 herbs in week 14 an
enter the new record for week 14 of this year. If we dont want to gro
anymore herbs that week the check box will be left blank and no ne
record will be created. If you have any questions please email me a
(e-mail address removed).

Thank

 

[Dinky]

*I have a continuous form bound to a query. The form has a heade
that specifies criteria for the query and then displays all th
records in the detail section. Each record includes 5 fields...Item
StockNumber, ReadyWeek, PotWeek, and Quantity. The records ar
displayed in rows. I would like to place a check box at the end o
the row. When the check box is checked 5 new txt boxes will appea
on the right side of the check box so that it is one long row.
would like these text boxes to edit information into a new record o
the query. However, I want the information displayed on the lef
side of the check box to continue to be displayed. What I am tryin
to do is this...

I have a greenhouse company and this form is used to schedule th
growing of plants...if we grew 100 herbs in week 14 last year and w
decide to grow 120 herbs in week 14 this year I would like to chec
the checkbox next to the record that says we grew 100 herbs in wee
14 and enter the new record for week 14 of this year. If we don
want to grow anymore herbs that week the check box will be left blan
and no new record will be created. If you have any questions pleas
email me at (e-mail address removed).

Thanks *

Hi,
I'm not that hot at Access but I don't think you can do what it is you
looking for.
Firstly I don't think you can have 2 records per row as when you have
multi-record form you define just one row and when in form view i
shows all records that meet the criteria _as_seperate_rows_.

What you could do is create the check box and when it is checked mak
the form go to enter a new record.

Sorry if this doesn't help

Dink