Beginner - How to look up & display referential data based on 2+ parameters in a form?

[00253]

Hello to whoever is reading this,



I don't have any experience with databases but I've picked up Access to create a statistic process control in my workplace. I can't figure out how to "build" the database with the functionality I seek. I just need someone to send me in a direction and then I'll self-learn; I just don't want to go through hundreds of pages of tutorials to find a solution. I'm self-taught in Excel + VBA and I can get around most of the problems when I need to (using VBA), but I want to know how to design this 'the right way'.

I'll use a flower example to ilustrate my case. This is the main table, "tabFlowers":

ID	Flower	Color	Price
1	ROSE	RED	2.60
2	ROSE	YELLOW	2.20
3	TULIP	RED	1.90

In my form "formLookup", I want to be able to select Flower and Color from two separate drop down lists, each with non-duplicate values. Then I want to autofill a textbox with the corresponding price (to 'look up' the price based on flower and color). What is the correct way to build the form and related components? Could this be achieved "live", just as Flower or Color are selected in the form?

I know this is a very broad question, but I've tried several times on my own and none of my solutions worked well. I wanted to used "DLookup" but I think it only allows to lookup based on a single parameter. I'll be using several parameters in my actual database.

Thank you for your time.

[pbaldy]

If you wanted to use DLookup(), you can certainly use multiple parameters. See the multi-parameter example at the bottom:

DLookup Usage Samples

[pbaldy]

I should add, depending on what the actual situation is, I might use a recordset instead. It depends on your specifics and what you're comfortable with.

[00253]

Thanks, pbaldy, I don't know why I never bothered looking if DLookup() can actually use multiple parameters. Seems like I'll be able to move on now. Thanks again!

[pbaldy]

No problem, post back if you get stuck.