Issues with records

[buckeye77]

2 issues that I need to fix

#1) how do I write code to say that once leaving a field, if the field is null, make it 0. This is in the event the user deletes an amount instead of making it zero

#2) I need a way to give a yes / no box to the user (yes = cancel record) if they leave the subform (or attempt to add another record to the subform) and any of the fields advanceamt / calyear / or advancedt of the current record is not filled in.
subform name = frmadvance
As long as the user completes those 3 fields, I can find the rest of the info to complete the record.

 

[buckeye77]

#1 solved.... after pulling what little remain hair I had out....

#2 still a mystery but will keep working... if anyone has suggestions or thoughts, I am wide open.

 

[jamaarneen]

Hi buckeye77,

It is somethibk you willneed to write in the form's 'BeforeUpdate' event. The 'Yes/No' - will be a MsgBox with some arguments.

Here is a link to a thread, about this issue.
Hope it will help you.

Ja

thread702-1490566