Dlookup in a qry for text value

[knuckelhead]

I give up. In my QryQuote. I have a calculated field named JunctionFormula.

I want to have my JunctionID (number, long integer) field in tblQuote to match up to JunctionID (autonumber, Long integer) in tblJunction. And then get me the FormulaId as my answer. Here is the Dlookup syntax in my QryQuote field JunctionFormula.

JunctionFormula: DLookUp("[FormulaID]","tblJunction","[tblJunction]![JunctionID]='[tblQuote]![JunctionID]'")

what am i doing wrong? the answer is not the proper JunctionID. I get the first formula in tblJunction. The dlookup quits at that 1st tblJunction record. if i am looking for JunctionID 3952, i always get formulaID for JunctionID number 1. the dlookup does not keep looking downwards. maybe i have a quote wrong somehow??

thanks

 

[knuckelhead]

Never mind. I just figured out something neat. I added the soldID, shipID and formulaID to the "link child and link master" sections in the subform, after making these fields in tblQuote.

In other words, i see that these 3 fields in the Main form table is capable to be SAVED in the subform's table.