Button doesnt run VBA code (1 Viewer)

[Fasopus]

So I'm in quite a pickle here and I have no idea why. I have a button at the bottom of a form that is used to edit some details. All it does is save the details and then run a few lines of VBA code, which disable warnings and run two action querys (one to append and one to delete) before re-enabling warnings. However if you connect to the form, edit something and push the button it doesnt work, if you drop out of the form and re-enter it you can see that you changes have been saved and then when you push the button it actually runs the VBA code. Does anybody have any ideas as to what causes this

 

[boblarson]

1. are you on Access 2007 or 2010?

2. If so have you set the database's location as a trusted location?

 

[Fasopus]

Im running Access 2007 and everything is inside of a trusted location. I seem to have fixed it now by adding the save function into the VBA code instead of having it in the macro and then having the macro call the VBA code, somehow the macro save wasnt working properly, hence the conditions of the action queries werent met and it would appear that nothing happened

 

[doco]

1. are you on Access 2007 or 2010?

2. If so have you set the database's location as a trusted location?

Those 'Ralph Nader' tactics of 2K+7 and later sure would be nice to disable altogether - a completely absurd notion to begin with...