Set a value with VBA

[astath]

Dear All,




I am currently using VBA in order to set a value of a field of a subform for each new entry. What I have found working is to use Units = Units.ItemData(0) under the Form_Current ()

The problem with this scenario is that if I select a field of a previous line, units get reset. Is there a way to perform what needed only once for each new row?

Thanks.

[ranman256]

no vba needed,
set the text box property: DEFAULT VALUE=6

[Missinglinq]

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.

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)>

[astath]

Thank you both for your help and prompt responses. Missinglinq despite the murky explanation from my side, not only you understood what I wanted but you solution works perfectly! Many thanks!!