select items on a form and save to another table

B

bpolite

I am having clients select items from a form which is bound to a table
(tblImage).After their selection they are to press the save button which is
to save their selections to another table (tblSelect). I would appreciate if
someone could help me in how to write the code behind the save which would
allow the record to be saved to another table or show a better way to
accomplish the task.

Thanks in Advance
 
G

Golfinray

Just use the command button wizard, go to form operations, pick save form and
your done.
 
B

bpolite

Thanks for the response but maybe I did not understand. I went into the
command button wizard to the form operations but did not see 'save form'.
What I did see was the following:

Apply Form Filter
Close Form
Edit Form Filter
Open Page
Print a Form
Print a Current Form
Refresh Form Data

I am using MS Access 2003 if that is any help.

Thanks
 
Top