Joe Hecht
jmhecht at earthlink.net
Wed Jun 22 19:02:13 CDT 2005
Kevin wins. Need more bangs and less dots. Joe Hecht Los Angeles CA -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kevin Bachmeier Sent: Wednesday, June 22, 2005 11:25 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Good Code Bad Code Question Try using the '!' instead of the '.' for the control reference: Me!txtCost.Value = Me!cboPartNum.Column(2) Versus: Me.txtCost.Value = Me.cboPartNum.Column(2) -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht Sent: Wednesday, June 22, 2005 1:01 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Good Code Bad Code Question The following line of code works correctly Me.txtCost.Value = Me.cboPartNum.Column(2) When I try to compile the code I get an error message that .cboPartNum Method or Data member not found. Any Idea what is up? Option Explicit is set Thanks Joe Hecht Los Angeles CA -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com