Combo Box Default Value Issue

  • Thread starter Thread starter FA
  • Start date Start date
F

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
 
Back
Top