vlookup in Subform

[dnjtdjq]

I'm a beginner in Access and I'm not sure if what I want to do is correct or possible to do in Access but I will give it a go.

Im trying to make a recipe template using Access Form and I have three tables I first made.

Combined Table, Ingredients Table and Recipe Table.

In Ingredients Table, I have 3 fields which are Ingredients ID, Ingredient and price.

In Combined Table, I have Recipe ID, Ingredients, Price, Amount and Total

When I made a Form, I have put Recipe Table as a main form and Combined table as a subform.

Then, in subform I have deleted Recipe ID.

What I want to do is the price field in subform to be auotmatically fileld if when I type Ingredients in subform ingredients field.

The dlookup formula I used in the control source of a combo box is =DLookUp("Price","Ingredients Table","Ingredient=" & [Ingredient Combo])

And no matter how I change the formula, the end result is #ERROR.

Any suggestions will be highly appreciated.
Thank you

 

[Joe4]

Cross-posted here: Using Dlookup in Subform

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.