adding textbox information to the table data and get it in

let's say i have such a structure for a table:

| year | product | amount |

i have a form, using text box'es like this:

year
product amount
product amount
....
product amount
(some of textbox'es (products and amounts) can be empty.)

i want to add these data to the table. how can it be done?

:::::: part 2 :::::::::
is it possible to get data from the table using similar form so that - when the user chooses a year, all the textbox'es are filled with the products and amounts of the year?

Hi,



Try a subform. In the main form, have a combo box with:

SELECT DISTINCT [year] FROM myTable


and have the subform linked to that combo box.




Hoping it may help
Vanderghast, Access MVP


"stilets" wrote in message
...
let's say i have such a structure for a table:

| year | product | amount |

i have a form, using text box'es like this:

year
product amount
product amount
...
product amount
(some of textbox'es (products and amounts) can be empty.)

i want to add these data to the table. how can it be done?

:::::: part 2 :::::::::
is it possible to get data from the table using similar form so that -
when the user chooses a year, all the textbox'es are filled with the
products and amounts of the year?