Dlookup in query using Global variable

[newwales]

Dlookup in query problem think it is to do with placement of “ or [ but not to sure.



I have a form “FRM_Data” within this form I have some data & a text box to enter the Price list, when you enter data into the Price list text box the data is stores as a global value “GL_Selected_Pricelist”

In Qry_data there is a field PriceNo that displayes the “GL_Selected_Pricelist” & a 2 Dlookup field.

Priceb is the one that works Priceb: DLookUp([price1],"pricelist",[tbl_code]=pricelist!code)

Price Dose not Work Price: DLookUp([priceno],"pricelist",[tbl_code]=[pricelist]![code])

If you can help I would like Price to work as this should lookup the data in PriceNo field & then look in the Pricelist table for the corresponding column heading & then find the value.

Thanks.

I have created a test database attached to show what I am doing.

[ssanfu]

Price Dose not Work Price: DLookUp([priceno],"pricelist",[tbl_code]=[pricelist]![code])

If you can help I would like Price to work as this should lookup the data in PriceNo field & then look in the Pricelist table for the corresponding column heading & then find the value.

From what I see, you don't have a "priceno" field in the table "pricelist". Therefore, you cannot have a return value for the DLookup().