Populating Pricing Details - Possible or too Complex?

[Curtis Stevens]

I'm not sure if this can even be done, but knowing Access, there is probably
a way as it is so awesome...

The best & easiest way I can explain what I'm wanting:

Please download Microsoft's "Orders Management" Template database, found here:

http://office.microsoft.com/en-us/templates/TC010185481033.aspx?CategoryID=CT011366681033

When you open the database, it pulls up the Add or Edit Orders Screen. In
the form, there is a subform, that has the order details, like product,
quantity, unit price, extended price, etc.

My question is it possible when you select a product and type in quantity,
it pulls the applicable pricing data for that particular product from your
table and automatically inputs that info into the unit price field for you?

I have my own db, but it’s the same concept I'm trying to figure out.

Any web site you can point me to that will aid me or even a sample database
I can download that has this functionality, so I can look at the coding, etc.
would be AWESOME!!! I get a feeling I need to use a macro of some sort?

Thanks
Curtis Stevens

 

[Curtis Stevens]

NEVERMIND! I saw that line in the macro, but it wasn't doing it so... I
redownloaded it and works, so that db is what I want, a working example!

Sorry!

Curtis