Record not writing to table

[ftook]

I have a form that has various inputs, combo boxes, radio buttons etc, the form is bound to a table. I am getting a problem that every now and again the user is entering the data but as SAVE button (a macro button) is selected the record does not write to the table and there is no warning that the record isnt being written.

on the save button i verify that all options have been selected and stop the user on null input, but i cant seem to see where the record is failing.

Is there any way i can debug to get the program to tell me what field/entry is missing that the record isnt being written.

 

[danvlas]

You should re-write the macro in VBA and use the F8 key to debug.

Any macro except AutoKeys should be scrapped and replaced by code. AutoExec included, as you have Startup Options.

HTH


Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[blastingm]

Use the FORM events... very useful for INSERTS and UPDATES..

BEFORE UPDATE
AFTER UPDATE

Put code in these events and when you DEBUG notice what happens in the sequence of updating.

Example:

Private Sub Form_BeforeUpdate

'Anything..here. Just trace if and when the program comes here

Mars

End Sub

 

[ftook]

thank you both for your help - i will try the suggestions