closing a form (1 Viewer)

[soundsfishy]

I have a search form and when the user click the name in the results, I need to form to close. I cant seem to make the search form close after frmProposerMain is opened. What am i missing!

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmProposerMain"

stLinkCriteria = "[ProposerID]=" & Me![lstResults]
DoCmd.Openform stDocName, , , stLinkCriteria

Me![lstResults] = ""
DoCmd.CLOSE acForm, "frmSearchPerson"

 

[dgm]

Nothing that i can see, unless u spelt frmSearchPerson wrong ...

What if u try closing the form before u open the other one?

Dim stDocName As String 
Dim stLinkCriteria As String 

stDocName = "frmProposerMain" 

stLinkCriteria = "[ProposerID]=" & Me![lstResults] 

Me![lstResults] = "" 
DoCmd.CLOSE acForm, "frmSearchPerson"

DoCmd.Openform stDocName, , , stLinkCriteria

 

[soundsfishy]

Yep!!! it did spell it wrong..dam dislexia!..hehe
It should have been frmSearchPeople..

Dont you hate when its something simple and obvious.


Thanks

 

[dgm]

Always a pleasure to help a fellow Aussie...

Even if u are from Melbourne!

 

[soundsfishy]

Us Melbournians are a bit slow on Modays!...probably from all the grog we comsume on Fridays