A1VBCode Forums

help with codings for save


http://www.a1vbcode.com/vbforums/Topic28298.aspx

By dryan - 10/18/2009

hello to everyone. lately i was able to create the database for the dental system

that i was making and was able to make it work but recently i made a few changes with the form

of the system and these changes are;

instead of text box I used combo boxes with the selection of yes and no.

my question is;

what kind of field type should i use in the table?

should i use text, boolean, integer?

and my other problem is that everytime i tried to save a sample record on the system i would

receive an error message that says

"run time error 3426"

" this action was cancelled by an associated object"

and i get the option

continue

end

debug

help

what i do is i select on debug and then it would of course stop the system and would

highlight the coding with the error.

the error is on the coding for my save button. can somebody please tell me the correct

coding for the save button.

my system has 3 major command buttons and these are:

SAVE

Data1.recordset.movelast

Data1.recordset.addnew

Data1.recordset.update



UPDATE

Data1.recordset.edit

Data1.recordset.update



NEW PATIENT

Data1.recordset.movelast

Data1.recordset.addnew

txtname.setfocus



can somebody tell me why am I receiving that error message?

please do help me T__T
By vb5prgrmr - 10/19/2009

See my answer in the other thread that you posted in