Values not auto-populating form

[Damian37]

Hello all,
I'm trying to get a field within my form to auto-populate, but it's failing, and I don't know why. I need a product description to be pulled from the data, and unfortunately nothing's happening.


As a SCSD Employee, when I select a Product SKU, I need the Product Description to auto populate in the form.

VBA Code (Current)

<code>
Private Sub cboSKUID_Change()
Me.txtPRODUCTNAME.Value = Me.cboSKUID.Column(1)
End Sub

</code>

As always, any help is greatly appreciated.

 

[Fluff]

How are you populating the combobox?

 

[Damian37]

How are you populating the combobox?

Hi Fluff,

I'm not trying to populate a combobox. It's a list view, and when I choose column 0, it populates my text box with the SKU number, but when I try to move over one column to the right in order to bring in the description, I'm receiving a blank result instead of the value within the column.

 

[Fluff]

I've never used ListView, but from what I've found you cannot use .column with listview.
So I'm afraid I'm unable to help any further.