Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Global vars in a A2010 web form?

16 views
Skip to first unread message

Salad

unread,
Nov 25, 2009, 5:35:26 PM11/25/09
to
I'm not near the computer that has A2010 but I was wondering...how does
on set a global var for a form? In VBA, at the form's top level we migh
have
Option Explicit
Option Database
Dim lngNum As Long
and lngNum would be available throughout. Is there a similar method for
a web form?

Albert D. Kallal

unread,
Nov 26, 2009, 2:53:59 AM11/26/09
to
"Salad" <o...@vinegar.com> wrote in message
news:UNOdnej3uZWzLJDW...@earthlink.com...


You don't have a forms level var. You do have global vars, and local vars.

And, keep in mind, you see for table event macors and table data macros, you
see you only have LOCAL vars, and no global (your data macro can't see/hold
values from the forms macro code).

However, you can pass values (parameters) from a UI macro to a data
macro....


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOO...@msn.com


0 new messages