Lookup ID after selecting multiple combo boxes

[craiggodbold]

Hi guys I'm need of some serious help here.
I have 3 drop down boxes where you can select the type of Sponge, Topping and Filling for the cakes. The 3 drop down boxes link to individual tables (toppings, fillings and sponges) In another table I have combinations of the toppings and an ID key for each combination.

When a particular combination is chosen from the drop downs is there a way to search for that particular combination and display the ID key in another text box from the combination table

Hope that makes sense

Thank you

Craig

[pbaldy]

You can use a DLookup() or recordset. You can create a query that uses the 3 combos in the criteria, which would guide you to the SQL for the recordset or the criteria of the DLookup:

DLookup Usage Samples

[craiggodbold]

Thanks very much for the reply. Very helpful. I was working with the lookup earlier but can get ahead around this problem. I have the set field name and the table name to go to where those combinations are but am lost as to what I put in the criteria.

Im my head it says looks at the contents of drop down menu 1,2,and 3 and then go to the query and find out what the id of that combination is. Easy in my head I just not have an idea on how on earth to get a text box to return that ID value

Text47 = DLookup("CakeID", "Cake Query", "Criteria =?'")

Thank you so much

**Sorry I meant to add before I posted it is the Criteria the 3 dropdown boxes that would create the combination (hopefully that makes sense)

[ssanfu]

PMFJI,

Using the link provided by Paul, you would use the bottom example.

Need to know the combo box names and the value type: number or text.

Using the combo boxes names of cboToppings, cboFillings and cboSponges,
if the combo box values are text in the table "Cake Query", the DLookup would be

Text47 = DLookup("CakeID", "Cake Query", "[toppings] = '" & Me.cboToppings &"' AND [fillings] = '" & Me.cboFillings & "' AND [sponges]= '" & Me.cboSponges & "'")

If the values are numbers, (no delimiters)

Text47 = DLookup("CakeID", "Cake Query", "[toppings] = " & Me.cboToppings &" AND [fillings] = " & Me.cboFillings & " AND [sponges]= " & Me.cbosponges )

Note: shouldn't use SPACES in any object names....... "CakeQuery" would be a better table name.

[pbaldy]

I'll get out of the way.