I have an application with two forms, let's call them frm1 and frm2. Initially only frm1 is open, and the sub that is run when a particular command button is clicked has code that ends with:
DoCmd.OpenForm "frm2"
Call ReviewConditions
In the module for frm2, I've created the ReviewConditions sub as public, i.e.
Public Sub ReviewConditions ()
However I'm getting a compilation error "Sub or function not defined" on the "Call ReviewConditions" statement. I don't understand why this happens if the called sub is defined as public.
Could it be because frm2 is being opened dynamically in the code for frm1? That's all I can think of, but I wouldn't have thought it was a compilation issue.
Any suggestions would be welcome!