[AccessD] Public Variables in a Report

Heenan, Lambert Lambert.Heenan at AIG.com
Thu Aug 7 13:58:36 CDT 2003


Yes. These two statements have identical effects...

	foo = Forms("SomeForm").SomeField

	foo = Forms!SomeForm!SomeField

but the first version is slightly faster in execution as the form name, as a
string, is the index into the Forms collection.

Lambert

> -----Original Message-----
> From:	Julie Reardon-Taylor [SMTP:prosoft6 at hotmail.com]
> Sent:	Thursday, August 07, 2003 2:02 PM
> To:	accessd at databaseadvisors.com
> Subject:	RE: [AccessD] Public Variables in a Report
> 
> Lambert,
> 
> 
> Thanks for your reply.  Isn't that the same as referencing the open record
> 
> from the form?  For example: Me.Hours111 = Forms!frmPayroll!F_shift1 + 
> Forms!frmPayroll!f_shift2 + Forms!frmPayroll!f_shift3
> 
> I need to be able to loop through the recordset created by the query and 
> then print the report.
> 
> 
> 
> Julie Reardon-Taylor
> PRO-SOFT OF NY, INC.
> www.pro-soft.net
> 
> _________________________________________________________________
> STOP MORE SPAM with the new MSN 8 and get 2 months FREE*  
> http://join.msn.com/?page=features/junkmail
> 
> _______________________________________________
> 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