Select ComboBox and Populate Other TextBoxes

[Cisco281]

I have a ComboBox (in the OrderFrm) that is looking at the PartsTbl. I would like to select the Part Number (in the OrderFrm)and auto populate the rest of the fields from the PartsTbl (CMD, Rev, Bios in the OrderFrm).

 

[LittleSmudge]

Assuming that the combo box control is called cboPickPart

and the Row Source is
PartsId, CMD, Rev, Bios

and that there are text box controls on your form called
txtCMD
txtRev
txtBios

THEN
In the cboPickPart_AfterUpdate event put

txtCMD = cboPickPart.Column(1)
txtRev = cboPickPart.Column(2)
txtBios = cboPickPart.Column(3)


'ope-that-'elps.




G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.