D lookup Formula on Subform

[dnjtdjq]

​Hello,

I am trying to make a recipe template with Access and I really need help on using d-lookup or search button so the price can automatically pop up.



So I have watched a tutorial on youtube on how to make a recipe template on access and basically did the same thing as the instruction but want to add a little twist to it. There are 3 tables that I created, which are ingredients table, recipe table and combined table.

Ingredients table consists of Ingredient ID, Ingredient and price.

Recipe Table consist of recipe ID, recipe and instructions.

Lastly, combined table consist of Recipe ID, Ingredients, Price, Amount and Total.

Like attached image, I used Recipe Table as my main form and added combined Table as my sub-form.

But when I added combined table as my subform I have deleted "recipe ID", so there are only 4 fields that are Ingredients, Price, Amount and total.

So basically what I want to do is if I choose the ingredient from the subform, the price automatically comes along with it.

In the price field, I have used dlookup that looks like "=DLookUp("Price","IngredientsT","Ingredient=" & [IngredientsID])" and tried many variations of this but never worked.

I would really appreciate it if anyone who is familiar with dlookup or knows what I am doing wrong could give me an advice.

[pbaldy]

More efficient and easier:

http://www.baldyweb.com/Autofill.htm

[pbaldy]

Though if I had to guess, ingredient should be ingredientID. But I'd go with the other method.