Show combobox only last and new record

[civl_eng]

Hi all, i have a table in form and user can choose number list of combo box, but i want after choose number of list, disable list in textbox and enable list only last and null record,



and i don't want to show combo box list in filled record again, combo box only enable in last and null record according picture.
thanks in advanced.(sorry, my english is weak)

[ranman256]

Don't quite understand what youre asking.
But i get the null.

[Gicu]

When you say "last" I believe you mean new record (the one on the bottom of your continuous or datasheet form (looks like a table but is actually a form). So technically you want to disable or lock the combo-box if the field is populated and enable it if it is null. You can do that in the OnCurrent event of the form or in the OnEnter event of the combo-box itself:

If IsNull(Me.YourComboName)=True then
   Me.YourComboName.Enabled=True
else
   Me.YourComboName.Enabled=False
end if

or with one liner like that

Me.YourComboName.Enabled=isnull(Me.YourComboName)

Cheers,
Vlad