D-Lookup

Originally Posted by GLEberts

I have a ton of DLookup results in by database and it works great.

However I just built a pop up form (fmswo) that I am using as a worksheet while viewing a invoice and when I click on the combo box (cbomesh) the choice comes up properly but populates the first value in the table where it is stored.

what I have:

where value is stored to be lookup up - "tblinventory"
field name to look up - "sellprice"
"cbomesh" control is - "meshtype"
combo box name = "cbomesh"

what I am using is:

=DLookUp("[SellPrice]","[tblinventory]","[meshtype] = '" & [cbomesh] & "'")

NOTE: It does not return an error but returns the "sellprice" of the product in the first record of "tblinventory"

I have tried countless combinations of solutions with no success.

Please help very frustrated with somthing that is probably very simple.

thanks
Gary

Originally Posted by GLEberts

...when I click on the combo box (cbomesh) the choice comes up properly but populates the first value in the table where it is stored.

Originally Posted by missinglinq

It sounds to me as if the your combobox is bound to the field in the table it pulls from, which it shouldn't be for this type ofthing. Is a field listed in the Ccombobox Control Source?

Linq ;0)>