Storing Form Fields?

[A|ex]

How do i store form fields into a table? on my form i have text boxes which work out calculations but i dont know how to store them. Does anyone have any ideas?

 

[dan-cat]

How do i store form fields into a table? on my form i have text boxes which work out calculations but i dont know how to store them. Does anyone have any ideas?

Why would you want to store them? It would just take up extra space in your db.

If you can present accurate data to the user without storing it then all the better. Your db will remain more compact and perform better.

 

[A|ex]

i need the data to generate reports of, some calculations cannot be worked out on the form because they require user input/ choices

 

[A|ex]

it seems to work for combo boxes, i generate a list of items and store it in a field.

MS Access asks me where i want to store the selected value, was wondering if there was something similar for form fields?

 

[A|ex]

nvm i figured it out, you have to change the record source on the form for it to store