Thanks, Kenny. Actually, I solved the problem with this form by setting default values in the form itself. That way, I do not have to start the form hidden. Your suggestion will come in handy, however, for the next part of my application where I do
have to pass values to the form before displaying it.
I noticed that Show was not one of the options presented for this form. I am confused about the difference between Show and Visible. Maybe someone can enlighten me.
What really goads me is that I wrote four applications in Access anywhere from four to ten years ago. Now, I cannot remember the first thing about it. Must be that "oldtimers" disease.
quote:Originally posted by Kenny Alligood
Sorry for the initial reply. I have taken your code and put it into a working db (I also really looked at it this time) and found this possible solution. First off the last line of your code is actually generating the error //Forms(strFormName).show Modal// due to the fact that .Show is not an option in this context. What I suggest is changing that last line to look like this:
Forms(strFormName).Visible = True
It accomplishes the same thing but doesn't generate an error. As for the modal property why not just set that in the forms property sheet? If you would rather set it in code you can use this:
Forms(strFormName).Modal = True
Hope this helps you.