By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 2,802 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

Run-time error 438

P: 1
I tried this code

Private Sub Ship_To_AfterUpdate()
' Update Customername controls based on value selected in Ship_To box.
Me!Customername = Me![Ship_To].Column(5)


End Sub

to take the information from the Ship_To field and populate the Customername field... but it tells me that the object doesn't support this propety or object...

Any thoughts

thanks
Tim
Jun 4 '07 #1
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
I tried this code

Private Sub Ship_To_AfterUpdate()
' Update Customername controls based on value selected in Ship_To box.
Me!Customername = Me![Ship_To].Column(5)


End Sub

to take the information from the Ship_To field and populate the Customername field... but it tells me that the object doesn't support this propety or object...

Any thoughts

thanks
Tim

Try changing this: Me!Customername = Me![Ship_To].Column(5)
......................to: Me!Customername.Value = Me![Ship_To].Column(5)

Also verify that column(5) is the correct column reference because column reference indexes start with zero for the first column on the left. Therefore if you intended to reference the fifth column from the left, you should have referenced column (4), not column(5).
Jun 4 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.