auto-fill help

[stephenchan433]

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

[Missinglinq]

So what is it doing/not doing? Column(X) is Zero-based, with the first Field being Column(0), the second Column(1) and so forth.

Does any code work? Access 2007 and later requires that the Folder the file resides in being declared as 'Trusted,' in order for code to run.

Linq ;0)>

[ItsMe]

These two threads should be merged.
https://www.accessforums.net/access/...ill-56292.html

[stephenchan433]

Thanks for the reply. I can see the columns in the drop down list but when I select one it will not populate.