Lookup OnHand Quantity F/ Products Table

[burrina]

I have a Products table. A Order Details table. A Order Details Extended Query. A subform named OrderDetailsSubform and Main form named OrderDetails.

Ok, I am trying to get OnHand (field in Products Table ) from the Products table onto my OrderDetailsSubform so the user can see what is in stock before making the order.
Every Query I have tried has not worked. Meaning, yes I can make a query that gets what I need but cant figure out how to add either a table or query to my existing ones and make it work without errors such as circular error.
Hopefully with the pictures attached you can make sense of this.Point me in the right direction.

1. Order Details is what the form OrderDetailsSubform is based on as showed on pic as Product Inventory Posting Sheet
2. Main Menu as show is based on the Table Orders.


3. I don't know (&*%%%) I am doing I guess!

[burrina]

Thanks, I got it. Had to rename a field,adjust code and all is well. Sorry for any of your time wasted.
I had a UnitPrice that was in both tables and prevented me from what i wanted.