AfterUpdate

[MaleNurse]

I have a form on which there are two fields I wish to work with.
I am trying to use AfterUpdate to clear the data from FieldB when FieldA is updated.
Can anyone help please

[meratigoerr]

in the AfterUpdate event use:

if me.fieldA &"" = "" then   ' or any other qualifier you may want
  msgbox "You didn't put anything in FieldA" 
else
  me.FieldB = null
end if

[MaleNurse]

No, that didn't work. I dont think I explained myself well enough either. The complete story is,
When the field "Medical Date" is updated i wnat the contents of the field ERT Medical to show a Null value.
Thats a better description

[meratigoerr]

to show a null value, or acutally be null??

if me.[medical Date] & "" = "" then
    msgbox "Please enter a date."
else
    me.ERT = null   'use if you want to erase the field
    me.ERT.visible = false  'if you want to hide the field, but not erase the data in it.
end if

try to avoid spaces in your fieldnames. it unnecessarily complicates things.

[MaleNurse]

Works perfectly. Thank you

[MaleNurse]

How do I add to yoru reputation mergatigoerr??????

[meratigoerr]

small star (6 points) under the "SharebThis Comment"

[pebbleslr]

I have a form on which there are two fields I wish to work with.
I am trying to use AfterUpdate to clear the data from FieldB when FieldA is updated.
Can anyone help please

Have you tried :

Private Sub FieldA_AfterUpdate()
Me.FiledB=Null
End Sub

[numus]

I have found random situations that = Null errors out...

In those situations (if you get any errors) just use = ""