Macro changes to form won't save

[Daryl2106]

Hi,



I added a couple of button to a form to load records from a query, save them to a table and close the form (three different buttons). The last one (to close the form) work when I wrote (rewrite) it but once the form is closed and reopens, the macro is not there. The marco is saved once written. Any ideas what I am doing wrong?

Take care,

Daryl

[alansidman]

Is the command button still there?

I don't use macros, but here is some VBA to accomplish this the same.

DoCmd.Close , ""

Put this in the on click event for the button.

[Daryl2106]

Thanks. Worked perfect. Just a follow up...why the double quotes? (This is my first experience with code).

Take care,

Daryl