paste/ update whole row

[56th Rowallan]

Hi all

Can anyone help me to paste/copy a whole row from a combo box eg

combo box lists [module],[date],[course director]

sub form has the same fields

i want to insert [module[, [date] and [director] from the combo box selection into subform. at the moment I select the module and that appears in the subform but not the rest of the data.

many thanks

Dave

 

[boblarson]

Put the data in by using:

txtModule = Me.cboYourComboBoxNameHere
txtDate = Me.cboYourComboBoxNameHere.Column(1)
txtCourseDirector = Me.cboYourComboBoxNameHere.Column(2)

 

[RuralGuy]

Since the actual data in a normalized Relational Database should only exist in one place, you may want to review your table structures. Except for special conditions, all that should be duplicated is ForeignKeys.