How do I append data from unbound form to a table?

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

Guest

I have a form that is unbound and uses a combo box and two multi-select list
boxes for end users to make selections. I want the selections made on the
form to be appended to a table that already exists. First, is this possible
and secondly how do I do it?
 
yes it's possible; you can append records with an Append query or via a
recordset opened in VBA code. is there a reason you don't want to just bind
the table to the form? that's usually the easiest solution.

hth
 
1. Yes, it is possible. However, this means that you are not using the
power of Access bound Forms where Access does a lot of things in the
background for you.

2. You can use VBA code to run an Append Query using the values the user
selects on the Form. Alternatively, you can open a Recordset and then use
the AddNew method to add a new Record into the Recordset and the Source Table
will be updated accordingly.
 
Back
Top