[AccessD] Set Focus on Form from Standard Module

Dan Waters dwaters at usinternet.com
Mon Jun 4 18:42:19 CDT 2007


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

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Monday, June 04, 2007 4:33 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Set Focus on Form from Standard Module

Arrrgh!  Syntax!

I have a procedure, called by different forms as a validation check of
sorts.

Public Sub TEST(cboPerson as ComboBox, frm as Form)

	'-- if things aren't right
	frm.cboPerson.SetFocus

End Sub

But of course this doesn't work.  What is the syntax?  Am I passing the
correct objects to the procedure?


Thanks!
Dan

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
 












































































































































































More information about the AccessD mailing list