I am trying to get a button to exit a form then open another form at the same time change a yes/no toggle.

Is this done in the query and from or just in the form.



[This message has been edited by johnhobbis (edited 04-15-2001).]

try this:

'close the form

docmd.Close acForm,Me.Name
'open the other form
docmd.OpenForm "FormNameHere",acNormal
'if the checkbox is on the form you just opened use this syntax to make the checkbox true.
Forms![FormNameHereAgain]!CheckBoxControlNameHere = True

hope that helps

Ian


[This message has been edited by Fornatian (edited 04-15-2001).]

Ian,

Thanks a lot am learning fast.......

Just change the toggle to the front because it triggers form the form that is being closed.

Thanks alot.