DTPicker null value

[qazz]

I used DTPicker in a form and its connected to a table employee with field name BirthDate with a datatype smalldatetime, but when i edit the record having a "null value", the DTPicker have encounter error " Binding Collection Error.... Field not updatable".

Anybody can help me.

Thanks,
Qazz

 

[RonRepp]

try:

If IsNull(RS("DateField").Value) Then
  DTPicker1.Value=Date
Else
  DTPicker1.Value=RS("DateField").Value
end if

I hope this helps.

Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.

 

[qazz]

Ron Repp,

Thanks but the data is connected in ADODC. They have error if you navigate the DTPicker if the fieldname value is null.

Arnold