using unbound form

[mkkashif]

hello
what is the best way to use a unbound form.
to save record through a button.
append query can be used for that purpose.
thanks

 

[trucktime]

Unbound

Not sure what you are trying to do, perhaps you can explain in more detail what you are trying to accomplish.

 

[mkkashif]

Enter Record in tables

hi
i want to enter records in tables throug a unbound form.
i dont want to use any control source and want to enter record
when i click on save button.
thanks

 

[trucktime]

Unbound

Wouldn't it be easier just to use a bound form and put some code in the Before Update Event of the form that enables you to select wether you want to save it or not?

Code like this:

Dim strMsg As String
strMsg = "Data has changed."
strMsg = strMsg & "Save this record?"

If MsgBox(strMsg, vbYesNo, "") = vbYes Then
'do nothing

Else
DoCmd.RunCommand acCmdUndo

End If