Capture Form Data to Populate Table

[Zachry]

I have a table (tbl1) already defined, but with no data in the table, some
fields have lookup to tables, and some fields have a LOV, used to limit our
users choices.

I have created a form based on table (tbl1) and 2 other tables.

What I want to do is have our users fill out the form and then I would like
to capture their choices and populate my table (tbl1) based on the choices
available in tbl1 and the other 2 tables as they close the form. Next time
they get back into the form, they can go through the same process and make
another set of selections.

What is the best approach to use in this case?

 

[Don Stover]

I have a table (tbl1) already defined, but with no data in the table, some
fields have lookup to tables, and some fields have a LOV, used to limit
our
users choices.

I have created a form based on table (tbl1) and 2 other tables.

What I want to do is have our users fill out the form and then I would
like
to capture their choices and populate my table (tbl1) based on the choices
available in tbl1 and the other 2 tables as they close the form. Next time
they get back into the form, they can go through the same process and make
another set of selections.

What is the best approach to use in this case?

 

[Zachry]

Additional information which i should have included:
I have a combo box with 6 fields: For the additional 5 that are not visible
after the combo box is closed, i have text boxes that display the value
underneath the combo box. These (5 fields) are the ones that i want to
capture and save to tbl1 upon exiting form or clicking a button.

thanks...