Combobox Oldvalue

[Isskint]

Hi everyone

This one has me stumped.
I have a bound combobox on a form (rowsource form a separate table). When trying to check the combobox.oldvalue in the BeforeUpdate() event, I get an "Invalid use of Null" error.
The combobox does have a value prior to triggering the event.

Oldvalue should work, right?

 

[arnelgp]

it is a bound combobox, then test first if OldValue is null.

if not IsNull(combldValue) Then
'your code
end if

 

[Isskint]

It s a valid suggestion arnelgp, but like i said in my OP, the combobox does have a value prior to triggering the event.

 

[Isskint]

ARGHHHHHHH!!!!!!!!!!:banghead::banghead::banghead:

The form was set as Data Entry. The combobox has a default value (which shows) but the combobox is the first control on the form so the record has no actual values yet.

i'm......just......gonna.........slip away.......quietly.....