Copying fields from combo box to a table

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.
 
D

Duane Hookom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo box based on a table to exclude data from second table 4
JOIN issue: Valid Syntax to refer to (In FROM clause) the Selected Fields from Query 15
Combine data from multiple tables into combo box 3
Setting the value of a choice in a combo box 1
Combo box not displaying field from SQL backend 1
Populating Combo Box from table based on selection - QUESTION 4
Using a combo box for setting a name 5
combo box to text fields of a table 1

Top