Hyperlink objects in database files

[P-C-Surgeon]

I created a data base that resembles a website with buttons (links) that take you to different user forms. Is there a way to click on a link and not only go to that form, but have the current form close so that data gets updated in the database. As it is now, I share this database with two other users, and the data only gets updated when they close each form. The way these forms are linked now, all forms stay open when you click on the hyperlink buttons. Any ideas? Thanks

 

[Tanis]

Just close the form with DoCmd, as in

DoCmd.Close acForm, "FormName", acSaveYes

 

[P-C-Surgeon]

Saving and closing form

Thanks for your answer. I will try the doCmd you suggested. I did however, figure out another way to do basically the same thing using a macro and having the save command as 'Yes'. Is it better using VBA, a Macro, or does it really matter?

 

[Tanis]

I would always use VBA, as this can be error trapped; macros can't.