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