>I have a procedure in the stored procedures of my database that I want to execute just prior to saving the form's record.
>
>I had originaly in the MyForm.Save event:
>*bof
>=MyProcedure()
>dodefault()
>*eof
>
>but it complained about some parameters to be passed. My procedure doesn't need any parameters passed so it has to be the save event itself.
>
>BTW the procedure executes OK if placed in the LostFocus event of a txtcontrol but i would mucho prefer to have it before the save of the form's record.
>
>Can someone tell me how to code the Form.Save event correctly ?
>
>TIA
>
>Pierre Richard
Pierre,
Myprocedure() doesn't want any parameters but what about default save code ? Might it be your save code requesting the parameters ? ie: dragover needs some parameters like oSource, nButton, Xcoord, YCoord. You would code it like this :
lparameters oSource, nButton, Xcoord, YCoord
=myprocedure()
dodefault(oSource, nButton, Xcoord, YCoord)
Cetin