Right almost too ashamed to ask this. I need to close a form, once another form has been opened.
I've set up the open form button with the following code:
Dim stDocName As String
Dim stDocName2 As String
Dim stLinkCriteria As String
stDocName = "Switchboard"
stDocName2 = "frm_leaflets"
DoCmd.Close , stDocName2
DoCmd.OpenForm stDocName, , , stLinkCriteria
New form opens, but existing form won't close.
I've set up the open form button with the following code:
Dim stDocName As String
Dim stDocName2 As String
Dim stLinkCriteria As String
stDocName = "Switchboard"
stDocName2 = "frm_leaflets"
DoCmd.Close , stDocName2
DoCmd.OpenForm stDocName, , , stLinkCriteria
New form opens, but existing form won't close.