Populating text control from Combo Box using DLookup 1

[DHSBW]

Hi:

Here is the following simple one code I have in the "On Change" event of combo12 combo box:

Private Sub Combo12_Change()
[Forms]![Orders Form]!Text25 = DLookup("[Unit Price]", "Products", "[Product Description]= '" & [Forms]![Orders Form]!Combo12 & "'")
End Sub


I want to use the selected value in Combo12, which gives a list of product descriptions, as the search criteria for looking up the unit price in the "Products" table, and then populating the "text25" text control on the same form with that value, which is a currency datatype. I'm getting a syntax error: Missing operator in query expression.... Thanks for the help in advance.

 

[genomon]

Maybe [Forms]![Orders Form]!Combo12.Text or
[Forms]![Orders Form]!Combo12.Value?

Before you criticize someone, you should walk a mile in their shoes.
That way, when you criticize them, you're a mile away and you have their shoes.

 

[PHV]

A safer way:

[Forms]![Orders Form]!Text25 = DLookup("[Unit Price]", "Products", "[Product Description]='" & Replace([Forms]![Orders Form]!Combo12, "'", "''") & "'")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[DHSBW]

Thanks. Got it to work.