macro question

[stuckagain1]

i have a macro that uses a dlookup command in the condition column. the macro stops here if the table that the dlookup command is looking in does not exist (the table exists to the extent there has been no user error). what is the best way to verify that the table exists, and if not, give message to user and then stop macro?

thanks!

 

[HitechUser]

stuckagain1,

Macros do not have good error trapping (Some people say step away from the keyboard with macros). I would suggest you select your macro (highlight it ) then from the Tools menu select Macro then select Convert Macro to Visual Basic. Then you can add real error trapping or test for your file.