Default Entry on Form 1

[kentwoodjean]

I have a drop down box of 3 items listed for a field called "Workaround". The choices are Yes, No, NA.
Originally I did the following but I get a "Complile error" when I try to click on any of the entries.

Private Sub WorkAround_AfterUpdate()
If IsNull(Me![Workaround]) Then Me![Workaround] = NA
End Sub

What I want to happen is for the field to default to NA if the user does not make a selection. Since there are multiple fields on this form and not all are necessarily filled out, I am now thinking that maybe it should populate with the default of NA once the record is exited.

Any help would be appreciated. Thanks.

 

[Remou]

This is a form, not a report, right ? Would it suit to just set the Default Value to "NA"?

 

[kentwoodjean]

Duh!! what was I thinking. Guess was trying to use all my new found knowledge and forgot how simple something can be.

Thanks for turning on the light bulb!