Convert Short SQL Query to VB ??

[ashlanddave]

Hi! Self-Taught and struggling a little.

I want to insert a unit price from an order into an order subform
(sbrparts). Each part(or product) has a pricing level of either a or b
(customers that buy more = get a better pricing schedule) AND each part has a
part number (from a combo box) on the subform. Essentially this query will
lookup in tablericinglevels and partID and PricingLevel to get the
UnitPrice and bring it back into the subparts form. I have stored this query
as unitpricequery and now it's time to insert into subform.

1. How do you insert a query into the control source for Textbox:Unitprice?
Will that then add the field UnitPrice into my subform automatically?

2. Can this query be written as VB and control source be named Unitprice?

Query
----------------------------------------------------------
SELECT Pricinglevels.UnitPrice
FROM Pricinglevels
WHERE ((([FORMS]![sbrparts].[Pricing])=[PricingLevels].[Pricing]) AND
(([FORMS]![sbrparts].[PartID])=[PricingLevels].[PartID]));

Thanks,
AshlandDave

 

[pietlinden]

If you're not going to override the price, why not just base the
subform on the query?