Clearing fields

[LynnaM]

I am currently using Microsoft's code for autofilling specific fields in a form set by the fields in the previous form. I have a very elementary understanding of VBA and was wondering if someone could offer me some suggestions. When I open the form I want to go to a new form but I want all the fields to be cleared. Currently I have a macro prompting for a new form but it autofills due to my code. Any suggestions or ideas would be greatly appreciated. Thank you.

 

[mikec]

Lynna,

You could insert this code into the OnCurrent event of your form;

If me.NewRecord = True Then 'Only do this if the record is new
me.FieldNameToBlank = Null
End If