Form Saving Problems

[mugman17]

I have a form that several people use. If they begin to use the form and do not complete a transaction ( I have a save command button) it still saves thte data. I would like it that if they do not hit the save command button it does not record the data into the table. I know this is quite easy. Its just not coming to me right now.

Thanks

 

[Fornatian]

I would suggest putting code behind the close button of the form which says in shorthand:

If "Do you want to save the record" = vbYes
then
'Save
else
'Me.Undo
docmd.close
end if

not tried this out yet but seems reasonable.

Ian

 

[Anauz]

how do you open the form in the first place? Access has differnet methods for you application of the form. The following will open the form in add mode.


Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Company_Details"

DoCmd.OpenForm stDocName, , , acAdd


you need to place this in the clicked event of a button or something

 

[Fornatian]

My mistake, still learning...