Thanks. That format works. I didn't quote the error messages because I got different ones depending on how I wrote the line of code, and I couldn't get into the database at the time I was writing the message. Sorry.
Sorry, I'll try to be more specific. Currently, I use this code to open the form Frm_EditCCBEsef:
DoCmd.OpenForm "frm_EditCCBEsef"
If I store the value "frm_EditCCBEsef" in the public variable "UseThisForm", what is the syntax (if any) that would allow me to use the variable instead of...
Is there a way to use the value in a public variable to open a form with docmd.openform? I want to be able to pass both the name of the form to be opened, and return to the calling form; the latter will be different depending on what's being done in the database.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.