You're going to have Unit reset every time you move to a different Record, using the Form_Current event.
To prevent this and only have it apply for New Records, which I'm assuming is your goal (your explanation is somewhat murky, at least to me...maybe just a lack of caffeine on my part) you need to check to see if it's a New Record before assigning the value...i.e.
Code:
If Me.NewRecord Then
Units = Units.ItemData(0)
End If
ranman256: You can't do that...the value isn't fixed...it depends on the data in the Combobox/Listbox maned Units.ItemData(0).
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007