Copying fields from combo box to a table

  • Thread starter Thread starter Archie_Phil
  • Start date Start date
A

Archie_Phil

Hi,
I am creating a database for our Machine Maintence Report (access 2003).
I created a combo box from table1 and I want to have the selected fields
(i.e. Machine, Technician, Engineer etc...) in table1 to be copied in table2.
This table2 has the same fields Machine, Technician, Engineer plus the other
field that will be updated when the maintenance is done such as remarks,
issue and data readings.

Looking forward for your help.
 
If you really have a need to store this information in multiple tables, you
can use code in the After Update event of the combo box to push the values
from columns in the combo box to fields on your form:

Me.txtMachine = Me.cboMachine.Column(0)
Me.txtTech = Me.cboMachine.Column(1)
Me.txtEngineer = Me.cboMachine.Column(2)

Columns are numbered beginning with 0.

Duane Hookom
MS Access MPV
 
Back
Top