Need help with auto-fill

Hi everyone,




Hoping that someone can help me as I am struggling to get my database to auto-fill. I basically want my raw material code (RM_CODE) to populate the following fields: "INGREDIENT", "RM MANUFACTURER", "RM SUPPLIER".


I have named my fields the following:
txtingredient
txtrm_manufacturer
txtrm_supplier
cborm_code


I have tried:
Private Sub cboRM_Code_AfterUpdate()
Me.txtINGREDIENT = Me.CBORM_CODE.Column(1)
Me.txtRM_MANUFACTURER = Me.CBORM_CODE.Column(2)
Me.txtRM_SUPPLIER = Me.CBORM_CODE.Column(3)
End Sub


any help would be appreciated!


thx

That looks like it should work. Have you adjusted the properties of your combo? I would double check the following ...
Column Count: 4
Column Widths: 0,1,1,1

These two threads should be merged
https://www.accessforums.net/forms/a...tml#post299831