adding textbox information to the table data and get it in

[stilets]

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?

 

[Michel Walsh]

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

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?