Assigning a default value

[thirty4d]

Hello,

I have a form that creates a recordset. I know that not every record will have a value in a particular control, but I don't want to leave a control blank.

Example:

Private Sub Form_Current()
If Me![txtInsert] = "NA" Then
Me![txtInsertDesc].DefaultValue = "NA"
End If
End Sub

But it's not working?

Thanks

 

[tempclerk]

I think the default value will only show up when you first open a blank record. Maybe you just want to set the value?