Gathering data from one table and sending it to another

[junkaccount]

In Access 2000, I want to create a form that upon initial data entry,
matches data from one table and places it in the form. The user will
then enter additional data in the form, at which point all data is sent
to a new table. For example, a user will enter a job number in a field
within the form which will call up related info from Table A and fill
in separate text boxes. The user will then fill in new information in
the remaining text boxes. Upon completion all information will be sent
to Table B. I have completed the initial task of getting the info from
Table A into the form by using a combo box. What I can't figure out is
how to send that info to Table B. I'm thinking it will have something
to do with the AfterUpdate function of the combo box but I don't know
exactly what and I'm just continuing to confuse myself. I'm kind of
flying in the dark with all this so the simpler the better.

Thanks!

Jason

[pietlinden]

I may be totally off, because the description of this problem is kinda
weird.

1. use a combobox to go to the record you want. Create the combobox as
UNBOUND. If you run the wizard, you should be able to go to a record.
Just run that.

"the remaining textboxes" - sounds like that should be a subform. No
reason to repeat all the junk in the main form anyway.

Data will automatically be written to the table the form is bound to...

Table B should be a bound subform...

Flying in the dark - you might want to read up on how Access and bound
forms work before going much further.