Bobby Heid
bheid at sc.rr.com
Fri Feb 16 12:42:28 CST 2007
Mark, I don't use macros, but if you can not use ELSE, then use the same IF statement, but make it negative. That is, instead of the equivalent of: If i=0 then something else something else end if use the equivalent of: If i=0 then something end if if i<>0 then something else end if Bobby -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte Sent: Friday, February 16, 2007 1:24 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Missing references Thanks Gustav, 1 last question if I may...I now see where the IF came from in the macro...but how in the macro would I have used an ELSE with that IF? Thanks, Mark A. Matte <snip>