Heenan, Lambert
Lambert.Heenan at AIG.com
Tue Jun 5 08:28:01 CDT 2007
Frm.Controls(cboPerson.Name).Setfocus ??? Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Monday, June 04, 2007 7:56 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Set Focus on Form from Standard Module Fred & Susan - thanks but I didn't explain enough. I'm using cboPerson as a variable, where the combobox name on each form will probably be different. Just like I'm using frm. Susan - these are passed ByRef - which is the default. Is this what you're asking? =======Dan, I couldn't really tell what you were doing with the references and what was going wrong. Let's start again. You're not getting the results you expect -- so tell us what you expect and what you're getting instead. If you said before, I apologize, maybe I missed it? If you referenced the form and control properly _before_ you passed it, it should work. The reason I suggested the Debug.Print at the very beginning was to test the variable -- to make sure it's actually getting passed correctly to begin with. Susan H. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.472 / Virus Database: 269.8.6/828 - Release Date: 6/1/2007 11:22 AM -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com