I have 2 forms in my database: frm_Main and frm_PInfo.
The frm_Main is where all of my links are for running reports, queries, exporting data, etc. The frm_PInfo is a form where a user can edit information from the tbl_PInfo, in a form format versus them trying to do it directly in the table.
When I am running items from frm_Main, for no reason that I am aware of, the frm_PInfo keeps opening. I have looked at the property settings on frm_PInfo and can find no reason for it to be doing this.Example: I have an item on the
frm_Main that simply opens a query for me to take a look at the results (code posted below). When I click on this link, it opens the query however it also opens
frm_PInfo.
Code:
Private Sub ctlControlSheets_LetterTypes_Click()
DoCmd.OpenQuery "qry_map_ControlSheet_LetterTypes", acViewNormal, acReadOnly
End Sub
Has anyone ever experienced this? If so, is there anything I can do to prevent this from happening?
Thanks!!!!
sren