Pass values in unbound control to a table

[fishtek]

Is there a method to pass values in unbound controls on a form to a table? Because of the table structure and for other reasons having to do with the users I would like to have the form act as a template with unbound controls and then pass those control values to a table at a later time.
Thanks for any help!

 

[PHV]

Use an APPEND or UPDATE query.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[fishtek]

Thanks for responding PHV. Please clarify. Ive used both append and update queries in the past but how do grab the values in unbound controls on a form?
Thanks

 

[PHV]

[Forms]![your main form]![your control]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886