Code

[Darrin]

I am trying to write code to clear certian fields on a form linked to a table. (ie. [last] [first] [social] but certian fields such as [room] [sex] and [org] should be left) can anyone help? It has been years since I have had to write code and it is showing.

 

[Dirk Goldgar]

I am trying to write code to clear certian fields on a form linked to
a table. (ie. [last] [first] [social] but certian fields such as
[room] [sex] and [org] should be left) can anyone help? It has been
years since I have had to write code and it is showing.

The basic code would be along the lines of

Me.Last = Null
Me.First = Null
Me.Social = Null

but the rest of it would depend on the circumstances.

 

[Darrin]

Thank you it worked like a charm.