combobox updating add'l fields? having to go to another record fir

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good Day,

I have a cbobox "cbodesignname" with the user selects the design from the
drop down, it is coded to update 5 additonal fields based on the design
table.

All my fields are not updating until I go to another record first....
Below is my code, does anyone have any tips/suggestions?

Thanks,

Brook

Begin Code:
Private Sub cbodesignname_AfterUpdate()
Me.DesignNumber = Me.cbodesignname.Column(1)
Me.CarpetNumber = Me.cbodesignname.Column(2)
Me.BaseColour = Me.cbodesignname.Column(3)
Me.FieldDesignColours = Me.cbodesignname.Column(4)
Me.SilkViscose_Colours = Me.cbodesignname.Column(5)
End Sub
End Code:
 
Brook said:
I have a cbobox "cbodesignname" with the user selects the design from the
drop down, it is coded to update 5 additonal fields based on the design
table.

All my fields are not updating until I go to another record first....
Below is my code, does anyone have any tips/suggestions?

Begin Code:
Private Sub cbodesignname_AfterUpdate()
Me.DesignNumber = Me.cbodesignname.Column(1)
Me.CarpetNumber = Me.cbodesignname.Column(2)
Me.BaseColour = Me.cbodesignname.Column(3)
Me.FieldDesignColours = Me.cbodesignname.Column(4)
Me.SilkViscose_Colours = Me.cbodesignname.Column(5)
End Sub
End Code:
Click to expand...


They should update as soon as you tab or click out of the
combo box, not necessarily when moving to a nother record.

If you want them to update immediately, try using the combo
box's Click event.
 
Back
Top