sja13
Professional Idiot
- Local time
- Today, 07:24
- Joined
- May 3, 2017
- Messages
- 63
Thnks to some great advice from forum members I was able to achieve opening a form using the following suggested code
The Form (which doesn't refer to Tables or Queries for any of its data sources) is visible, and I can interact with it.
My problem is now dismissing the form.
I have a couple of buttons on the form (effectively "Do it" and "Quit"), and when they are clicked, in the button's Click event I coded
The form doesn't close!
I also tried
with the same lack of effect.
I've spent a few hours with Mr. Google, and AWF's search engine, but everything I've found suggests the code should work.
I suspect it may be related to either the Datamode or Windowmode, but I can't find anything about those parameters that suggests they require a special form of Close command.
Any helpful soul got any ideas???
Code:
strForm = "frmReportFilter"
DoCmd.OpenForm FormName:=strForm, _
View:=acNormal, _
DataMode:=acFormPropertySettings, _
WindowMode:=acDialog
The Form (which doesn't refer to Tables or Queries for any of its data sources) is visible, and I can interact with it.
My problem is now dismissing the form.
I have a couple of buttons on the form (effectively "Do it" and "Quit"), and when they are clicked, in the button's Click event I coded
Code:
DoCmd.Close acForm, _
Me.Name, _
acSaveNo
I also tried
Code:
DoCmd.Close acForm, Me.Name
I've spent a few hours with Mr. Google, and AWF's search engine, but everything I've found suggests the code should work.
I suspect it may be related to either the Datamode or Windowmode, but I can't find anything about those parameters that suggests they require a special form of Close command.
Any helpful soul got any ideas???