OnClick event doesn't fire unless I switch to design view back to form view

[Seamus59]

I have a form I create programatically, and it has "Save" and "Discard" buttons. On a previous job it works pefectly, but in my current project it does not.



The buttons and supporting OnClick code seem fine but when my progam opens the form, the buttons don't work unless I change from form view into either Layout or Design, then change back to Form View, then they work perfectly. Perhaps someone has had this problem before and knows if there is a way to get Access to "reset" whatever it needs when the form loads.

[June7]

Why do you create form programmatically?

At a minimum, you should post the code for analysis. If you want provide db, follow instructions at bottom of my post. Identify object involved.

What do you mean by 'previous job' - a different db file?

[Missinglinq]

...On a previous job it works pefectly, but in my current project it does not...

...the buttons don't work unless I change from form view into either Layout or Design, then change back to Form View, then they work ...

From v2007 forward Access files need to be in a Folder that has been declared as 'Trusted.' If this hasn't been done, code will run when going from Design View to Form View, but not when the Form is independently opened in Form View. Perhaps this was done in your previous project but not in this one?

To "Trust" your folder, click:

• Office Button (top left)
• Access Options (bottom of dialog)
• Trust Center (left)
• Trust Center Settings (button)
• Trusted Locations (left)
• Add new location (button)

The code works, when going from Design View to Form View, because the Access security is only invoked when opening the Form directly, i.e. clicking on the Form in the Navigation Pane.

Like June7, I'm curious/concerned about your statement "I have a form I create programatically." This type of thing is usually a very bad idea.

Linq ;0)>

[Seamus59]

Thanks for your suggestion. It was a good one, but the trust settings are identical between the working and not working databases.
A little explanation:

I designed a database that creates a form programatically, which allows a supervisor to decide which questions should appear on a form. It works wonderfully. Then I made a duplicate of that database to modify for a different application that needs the same flexibility. It works almost as good as it's parent, except when the form opens, the buttons "Discard" and "Save", while clickable, do not work. I can click one and the other and they get focus, but the onclick event never occurs. I simply right click, change to "Layout" or "Design" view and immediately back to form view and they work!?!

Now that I'm writing this, I'm going to try the "On Got Focus" event and see if that fixes it..

I'll Keep you informed!

[Seamus59]

Well, "GotFocus" doesn't work either, although the command button clearly has focus...

[Seamus59]

Wow, figured it out...

I (previously) define all the controls on the form, save it, then defined the module...Well it worked in the previous database (I don't know why) but not on this one. But when I move my:

DoCmd.Close acForm, frmNew, acSaveYes
DoCmd.OpenForm frmNew, acNormal, , , acFormEdit, acIcon, intTargetID

to AFTER module definition, it works! YAY!

Now I have changed them both to the (more logical) "Finish, Then Save!" Duh!