I cannot get a form to close with out manually doing it.
I have used in code
DoCmd.Close, "myform" (when you run the code you can see it step trough it)
DoCmd.Close,acform, "myform" (says it cant save while processing a form)
This is on a textbox that is invisible, but enabled and it does not close
the form
any ideals?
I don't know what you mean by "this is on a textbox ...", but your syntax is
incorrect. After "Close" there is no comma, just a space. Here is a generic
version of the "Close" command:
DoCmd.Close acForm, Me.Name
Place this in the "OnClick" event for a command button (set the "On Click"
property to "[Event Procedure]" and then click on the "Build" (...) button next
to that setting. Then enter the line between the "Private Sub ..." and "End Sub"
lines in the code window).