A button that closes form, but opens another

[Robson8112]

I need to know how you can have a button on a form that closes the form that its on when clicked but opens another different form at the same time. Can anyone help??

 

[gusbrunston]

Hi:
You could use a macro with two actions: "Close" and "Open Form".

Put the macro name in the On Click event in the button's property sheet.

You could also do this in VBA:

Dim stDocName As String
DoCmd.Close
stDocName = "NameOfFormToOpen"
DoCmd.OpenForm stDocName, , , stLinkCriteria

I hope this is helpful.

Gus Brunston An old PICKer, using Access2000.

 

[gusbrunston]

Hi, me again.
The last line in the VBA code above
doesn't need the ", , , stLinkCriteria" Gus Brunston An old PICKer, using Access2000.

 

[Robson8112]

Cheers mate, i just needed to add in the DoCmd.Close

Thanks for the help.