adding textbox information to the table data and get it in

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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 -
Click to expand...
when the user chooses a year, all the textbox'es are filled with the
products and amounts of the year?
 
Back
Top