beginner's question

  • Thread starter Thread starter bw
  • Start date Start date
B

bw

Hi Guys,

I have a form that starts off with a combobox, this
combobox once you pick your users group populates three
textboxes with further details about your users group -

this is all so you can add a new employee id to your user
group in a fourth text box. What i need is when you click
the add record button that it saves this new record to a
different table.

This table will be empty but will have the same layout as
the table that it is getting the information from.

what I have so far is that this form opens in edit mode
(from the switchboard) and the combobox is pulling the
information from TLB_EMP and what I need it do is when you
cliock on add record that it saves everything to
TBL_EMP_NEW.

does any of this make sense?
rgds
BW
 
if your record is unique then create an append query using the information
from table TLB_EMP to insert the information into TBL_EMP_NEW. set the
criteria to the unique value in TLB_EMP.....say it is field ID then set the
condition to ID = forms!yourformName!ID. In the click event of the button
use docmd.Runquery "QueryName"
 
Back
Top