Change field entries with command button

[steve goodrich]

Hello
Can anyone help me with this

I would like to amend 5 fields on my form with the click of a button. the
first field will display EX SYGDC, the next 2 fields will display 0, the
forth will display today's date and the fifth field will be deleted.

I've done the first 4 ok (see below) but how do I delete an entry in a
field?

Private Sub Command111_Click()

Me.DEPARTMENT = "EX SYGDC"
Me.CHARGE_CODE = "0"
Me.PAYROLL_CODE = "0"
Me.EXIT_DATE = Date
Me.FIRE_COURSE_ATT = (I want this field to be blank)

End Sub

many thanks

Steve Goodrich

 

[fredg]

Hello
Can anyone help me with this

I would like to amend 5 fields on my form with the click of a button. the
first field will display EX SYGDC, the next 2 fields will display 0, the
forth will display today's date and the fifth field will be deleted.

I've done the first 4 ok (see below) but how do I delete an entry in a
field?

Private Sub Command111_Click()

Me.DEPARTMENT = "EX SYGDC"
Me.CHARGE_CODE = "0"
Me.PAYROLL_CODE = "0"
Me.EXIT_DATE = Date
Me.FIRE_COURSE_ATT = (I want this field to be blank)

End Sub

many thanks

Steve Goodrich

Me.FIRE_COURSE_ATT = Null

 

[steve goodrich]

many thanks Fred

Me.FIRE_COURSE_ATT = Null

 

[Rick Brandt]

Hello
Can anyone help me with this

I would like to amend 5 fields on my form with the click of a button.
the first field will display EX SYGDC, the next 2 fields will display
0, the forth will display today's date and the fifth field will be
deleted.
I've done the first 4 ok (see below) but how do I delete an entry in a
field?

Private Sub Command111_Click()

Me.DEPARTMENT = "EX SYGDC"
Me.CHARGE_CODE = "0"
Me.PAYROLL_CODE = "0"
Me.EXIT_DATE = Date
Me.FIRE_COURSE_ATT = (I want this field to be blank)

End Sub

Me.FIRE_COURSE_ATT = Null