Use of Form to supply Parameter Query Args

[jim may]

I've got a form used primarily for 3 parameter inputs (1 text; 2 dates). I have a button thereon which Previews a Report based on the query being produced. The code under the Print-Preview button references an Embedded Macro to Open Report. Currently, I want to provide error-handling "IF" any one the 3 input fields is blank and or 2, or 3 fields ARE NOT Dates (as they should be). Should I, or better do I need to - change from the use of an Embedded Macro to Code for this? I see that in the Macro Window there is a provision for "On Error", but I do not understand how it works. If I went with code instead what would that code look like?

Thanks, Jim

 

[alansidman]

Jim, I personally prefer the VBA road. If I use a wizard to automate and it creates an embedded macro, I always use the conversion wizard to change it to VBA so that I have more flexibility. On the developer tab on the ribbon, the icon is on the far right. As to error-handling, it will work very similar to how you would do it in Excel. BTW, when you convert the macro, it automatically places some generic error handling.

Alan

 

[jim may]

Alan, Thanks for the tip(s). always appreciated... Jim