Need some information on how to link a Textbox to a Combo Box

[DuWayne]

Form:
Parts PDCA
Combo Box is on Parts PDCA form pulling PartNo from tblBomPartMaster

Name: cboBomPart
Control Source: PartNo (places the data in tblPartsPDCA.PartNo)



Text Box is on Parts PDCA form
Want it to pull the part description when thecboBomPart the PartNo is chosen.

Name: tbbomdesc
Control Source: Part Desc

In the tblBomPartMaster:
Column (0) is the ID
Column (1) is the PartNo
Column (2) is the PartDesc

[alansidman]

Look at this

http://www.baldyweb.com/Autofill.htm

[DuWayne]

I still cannot get the testbox tbBomDesc to populate when I chose the cboBomPart.

Here is my setup:

Name: cboPartNo
Control Source: PartNo (Saves the data in tblPartsPDCA.PartNo)

Name: tbBomPart
Control Source: PartDesc (places the data in tblPartsPDCA.PartDesc)
AfterUpdate: [Event Procedure]

Private Sub tbBomDesc_AfterUpdate(Cancel As Integer)
Me.tbBomDesc = Me.cboBomPart.Column(2)
End Sub

[Missinglinq]

The assignment line

Me.tbBomDesc = Me.cboBomPart.Column(2)

needs to be in the

cboBomPart_AfterUpdate

event, not where you currently have it, in the

tbBomDesc_AfterUpdate

event! You cannot assign a Value to a given Control in the AfterUpdate event of that Control.

Linq ;0)>