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.

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