J
JAD
Hello
I have set up my forms, macros from the Microsoft Office Assistant "Create a
form to enter report criteria". I created the unbound form and put in my
text boxes for the criteria I want to query by. I set up the open dialog,
close dialog, ok button, cancel button macros and saved them all in a macro
group. I added the ok button to the unbound form. I entered the criteria
into the underlying query. I ran the query to ensure I would get the data I
am requesting, and it works fine. I attached the open and close macro to the
to the main report and when I open the report the unbound form pops up as it
is supposed to. I enter my criteria and then I get the the following
message: "The expression you entered has a function name that Main
Switchboard can't find". I close this error window and my report then comes
up as it is supposed to. Does anyone know why I may be getting this error?
Thank you in advance for any input.
JAD
I have set up my forms, macros from the Microsoft Office Assistant "Create a
form to enter report criteria". I created the unbound form and put in my
text boxes for the criteria I want to query by. I set up the open dialog,
close dialog, ok button, cancel button macros and saved them all in a macro
group. I added the ok button to the unbound form. I entered the criteria
into the underlying query. I ran the query to ensure I would get the data I
am requesting, and it works fine. I attached the open and close macro to the
to the main report and when I open the report the unbound form pops up as it
is supposed to. I enter my criteria and then I get the the following
message: "The expression you entered has a function name that Main
Switchboard can't find". I close this error window and my report then comes
up as it is supposed to. Does anyone know why I may be getting this error?
Thank you in advance for any input.
JAD