I want to avoid the usual Access multiple form hell by placing my different forms in a subform window on my main form = one form, one level all the time.
I change the forms like this:
How do I put in a criteria for what record "frmAnotherForm" should go to after it's been loaded on the main form? If i DoCmd.OpenForm... it opens out of the subform window. If I DoCmd.GoToRecord... it says form is not open...
The criteria should be based on what was on the initial subform.
Is this poor practice by the way???
I change the forms like this:
Code:
frmMain.SubFormWindow.SourceObject = "frmAnotherForm"How do I put in a criteria for what record "frmAnotherForm" should go to after it's been loaded on the main form? If i DoCmd.OpenForm... it opens out of the subform window. If I DoCmd.GoToRecord... it says form is not open...
The criteria should be based on what was on the initial subform.
Is this poor practice by the way???
