Order Details Subform

J

jenni_p

Hello -
I have a simple purchase order and I have run into a
snag.
My subform contains products from tbl_products and the
prices for the product are in tbl_productPrices.
The price should be the one that where the OrderDate from
the main form is between the StartDate and the EndDate of
the product price. I have it working so the proper price
shows up, but now I cannot add or change any products in
my subform.
Do I have to do this some other way besides entering the
criteria in the supporting query behind the form?
Thanks,
Jenni
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

show 2nd field when combo box choice is made 4
Return a value entered in a sub form field to a field in main form 5
How to Update a form: requery, recalc, refresh from subform entry 5
Wierd Results from a combobox and recordsource 1
ORDER DETAIL SUBFORM 0
Subform dependent combo box 4
Subform within a form 1
Order form for bundled products 1

Top