changing forms

[shaman7800]

i have a goto button, to change the form your working in, is there a way to target the same window for the new form to open?

 

[Bigpapou]

I don't know if this is what you need but it'll do the trick if you wanna a change one form for another in Access.

In the onclick code of your goto button just put this code

'go from "form1" to "form2"
Private Sub GotoButton_Click()
Dim strForm1 as String
Dim strForm2 as String

strForm1 = "form1"
strForm2 = "form2"

'first you open the form2 then you close the form1
docmd.OpenForm strForm1
docmd.close strForm2

End Sub

"There's never enough time to do it right but there's always enough to do it over"
From: "Bigpapou's book of things to write at the end of a post"