memo field not updating in tab control

[millrat]

Hi there,
I have a check box on my form which checks if fields are filled in or not.

Here's part of the code (BeforeUpdate)

Case IsNull(Me.strScope)
MsgBox "Please enter a Scope of Work.", vbOKOnly
Cancel = True
Me.Approved.Undo
Exit Sub
Case IsNull(Me.memHazard)
MsgBox "Please enter Hazards.", vbOKOnly
Cancel = True
Me.Approved.Undo
Exit Sub

strScope is text field on form; memHazard is memo field on tab control.

The memo field does not update until the record is saved. Whereas the text field does.

Any ideas here
Thanks

 

[lameid]

It seems like you are trying to use a select case statement instead of a series of IF statements. I think you want if statements.

Otherwise, you should post all your code as nothing is jumping out at me. Also is this beforeupdate for the form or which control is it for?

 

[millrat]

Hi,

I have worked around the problem thanks anyway...
Cheers