IIf

[shijuantony2002]

I guess the main problem should be that intellisense is not identifying the object of the list box. The field [Base_Curr] is not been identified and so dlookup might not be working as the object of data member is not found.

Any way out?

 

[Brianwarnock]

I don't know what your problems with intellisense are but they do not influence the code, just make it easier to get correct.
The DLookup works, and the result appears in the undefined Variant Base_Curr , I do not understand what you want to do with this, I thought that you wanted to populate the Form, in which case put the control on the form and then change the DLookup to Me.Base_Curr= DLookup,,,etc.

I am not aware that you can populate anything other than a variant defined in the code or a control on the Form.

Brian

 

[shijuantony2002]

thanks brian, i figured out, why intellisense was not working. To refresh the intellisense i removed the link from list box and reloaded, and it worked.