Combo box value

  • Thread starter Thread starter Rpettis31
  • Start date Start date
R

Rpettis31

I have a combo box that looks at an orders table. I am finding that I have
set up the table wrong or I am doing something else wrong. For example is I
am to call order PO1234 there could possibly be 50 lines on this specific
order and in the past you can see the Order Number and the specific line in
the drop down and can select it and that information would fill in other
order details. Now it seems it will only pull a few of the lines or just one
of the lines.

Private Sub CmbxOrderNumber_AfterUpdate()

' Assigns Values to fields based on Combo box order Number on form

Dim FactoryName As String

Select Case CmbxOrderType.Value

Case "PO"
Me.TxtVendor = Me.cmbxOrderNumber.Column(10)
Me.txtLine = Me.cmbxOrderNumber.Column(4)
Me.txtItemDescription = Me.cmbxOrderNumber.Column(3)
Me.txtSpecificationNumber = Me.cmbxOrderNumber.Column(4)
Me.txtStdCost = Me.cmbxOrderNumber.Column(5)
Me.txtBuyer = Me.cmbxOrderNumber.Column(7)
Me.txtFactoryName = Me.cmbxOrderNumber.Column(8)
Me.cboItemNumber = Me.cmbxOrderNumber.Column(3)
Me.cboItemNumber.ColumnWidths = "1in"
 
Back
Top