Close/Save button

[Hellfire]

Hi all,

I have a switchboard. When my users click on the button that opens my form to enter the information of a new record, it automatically goes to a new record. (I used te GoToRecord setting)

On the above form, I have an OK button, when my users have entered all the information, the click the ok button and the form closes. For this, I have only used a macro, and set it to Close and then selected the form to close from the list.

This works, BUT....I would like to know if there is another way of doing this. Is there any specific way for closing a form after new data has been entered?

Just want to know, as I believe that the "close" action on my OK button is causing conflict with my cancel button. (lol!!)

Thanks

 

[bluey]

There isn't realy a specific way of closing a form you could try using the wizzard.

To do this go in to design view of the form you are using make sure the wand icon on your Tool box menu is pressed in, then place a button on your form the wizz will then allow you to choose an option.

itl be in from operations bit
hope this helps

 

[dgoulston]

there is a way. i use it for a please wait form.

i have a form that makes reports and things and one of the reports has to do alot of calculation so it takes a while so while it is doing it it opens a form saying please wait and when it is finished it closes it using a little bit of code:

Dim stDocName As String
stDocName = "pleasewait"
DoCmd.Close acForm, stDocName, acSaveNo


"please wait being the form name"
so you could set it so that when they have entered the last peice of data it closes it.


hope that helps

DAL