Susan Harkins
ssharkins at setel.com
Mon Jun 4 18:55:39 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, 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