The DLookup in the query will work if you do the simple edit I described - remove the unnecessary space in the table name.

However, even with the edit the DLookup on the form won't return any result because it references [Forms]![Orders]![UnitPrice] and UnitPrice is not on the form. The form is unbound and there is no textbox named UnitPrice.