Combo Box Default Value Issue

[FA]

I have a combo box on a form in which there are two values in the
lookup table.

DA_ID DA
qr02a Yes
qr02b No

The data is coming from sql server, i want to be able to insert and
display "NO" if there is no data in that field.
DA_ID is a (FK) in table SYS_INFO so the all the values for DA_ID is
going into SYS_INFO.

On the Form Load event i have the following codes;

If Nz(Me.DA_ID) <> "" Then
Me.DA.Value = DA.ItemData(1)
End If

Where DA_ID is the ID for the lookup table and DA is the name of the
combo box.

But unfortunately its not working.


Please help me out.

Thanks
Moe

 

[Guest]

Your NZ statement is incorrect.

If Nz(Me.DA_ID) <> "" Then should be
If Nz(Me.DA_ID,vbnullstring) <> vbnullstring Then

-Dorian