Textbox control for user input of Quantity

[BigBlueScreen]

Hi,

I'm really stuck..I have a subform in which I have 3 fields
Item(combo3), Quantity(TxtQuantity), and Price(TxtPrice). I need to based off of user input match a qty on TblPrice and return a price to user on form. ANY help with this would be greatly appreciated.

Thanks again,

Jd

 

[PHV]

Take a look at the DLookUp function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[BigBlueScreen]

From what I've read this seems to be the answer..Thanks for putting me on the right track. Will post back after I have a chance to play with it.

Jd

 

[BigBlueScreen]

Hi,

If I was going to use Quantity (Qtylow and QtyHigh) as a range how would I structure my statement using Dlookup.

Thanks for the help,
Jd

 

[PHV]

Take a look at the Between .. And operator.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244