Compile error: method or data member not found

Question

When I try to compile, I have been getting this error saying "Method or data member not found".

This is the code:

Set db = CurrentDb
Set rec = db.OpenRecordset("Select * from SuppliersT")

rec.AddNew
rec("SupplierName") = Me.SupplierAddNameTxt
rec("Address") = Me.SupplierAddAddressTxt
rec("City") = Me.SupplierAddCityTxt
rec("ProvinceState") = Me.SupplierAddProvinceStateTxt
rec("PostalZip") = Me.SupplierAddPostalZipTxt
rec("Phone") = Me.SupplierAddPhoneTxt
rec("Fax") = Me.SupplierAddFaxTxt
rec("Email") = Me.SupplierAddEmailTxt
rec("Notes") = Me.SupplierAddNotesTxT
rec.Update

It highlights the Me.SupplierAddNameTxt in

rec("SupplierName") = Me.SupplierAddNameTxt

I have a textbox named SupplierAddNameTxt on the form the button is located on, and that's why I am trying to set that up to. Not sure why it's doing this. Help would be much appreciated!

Is this code placed in the private module of the form, say frmAddSuppliers ? — jacouh
– jacouh, Commented Nov 4, 2013 at 13:33
Private Sub MenuDatabaseBtn_Click() It is placed in the onclick event of a button, named MenuDatabseBtn. — D347HxD
– D347HxD, Commented Nov 4, 2013 at 13:36

jacouh · Accepted Answer · 2013-11-04 13:46:36Z

1

I created a form frmTest, added the control SupplierAddNameTxt, with your code, there is no compiling error.

So please check orthograph of the word SupplierAddNameTxt of the control name on the form.

You might type SupplierAddNameTxt in caption instead of the property name.

answered Nov 4, 2013 at 13:46

jacouh

8,8055 gold badges36 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Compile error: method or data member not found

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related