Writing to a table from a form

[kealaz]

Hi,

I have a form, that get's it's information from tblPOTODO. The information
is for parts that need to be purchased. In the form, selections are made to
choose the manuf of the part to be purchased and the vendor that the part
will be purchased from. Once those selections are made, I need to write all
that information to another table, tblBUY. How do I do this? I think I need
to create a command button... but do I use one of the already configured
buttons, or will I need to write a macro? or other coding?


Other info...

Form Name: frmPOTODO_process
Info coming from: tblPOTODO
Info going to: tblBUY

On the form, there are 3 combo boxes and 2 text boxes.
Combo boxes:
PART_NO --- goes to field PART_NO in tblBUY
chooseMANUF --- goes to field MANUF in tblBUY
chooseVENDOR --- goes to field VENDORNAME in tblBUY
Text boxes:
DESCRIP --- goes to field DESCRIP in tblBUY
NAME --- goes to field NAME in tblBUY


Other information that needs to get from tblPOTODO to tblBUY after the
vendor selection is made includes...
MANUF_PN
QTY_ORDER
TAXABLE
DELIV_TO

This information is not on frmPOTODO_process, because it is not needed to
make the MANUF and VENDOR selection, however it does need to go along. Can I
do this all in one step? or do I need to bring all that information into the
form, via text boxes and then write it to tblBUY when I write the other
information?


Thank you SO MUCH for all of your help with this.

 

[GBA]

make a form sourced on your tblBUY

inset this form as a subform into your first form

as you select items in the main form; have their values written to the
appropriate fields in the subform; this can be triggered in the AfterUpdate
event for each field.

it is not clear if there is suppose to be - or needs to be - a cross
referencing field between the main form record and the subform record.
wizard will prompt for one when you insert the subform, but it is not
required.