Multiple cascading combo boxes from single datasheet

[CRobledo]

I'm trying to make cascading combo boxes to narrow down the options for the user on entry. I was able to get the first and second combo boxes to work. here are screenshots of the code for the first combo box named orchard and this is for the second. The issue is the third box. I cant get it to filter based on the 2 boxes above it. it only filters based on one of them. Here is the table the data is stored. Does anyone know what I have to write for it to look at both? Side note I know the other option is to separate the data into multiple tables and build relationships but for the purpose of this database I have to keep the data in one table. Thanks in advance!

[ranman256]

just as you did for cbo2, set cbo3 to look at cbo1 and cbo2, AND the afterupdate event must refresh the list

cbo3 sql:
select [field] from table where [orchard]=forms!myForm!cmbOrchard and [commodity]=forms!myForm!cmbCommodity

but each combo AFTERUPDATE must refresh the next combo down the list

sub cboOrchard_afterupdate()
   cboCommodity.requery
end sub

[CRobledo]

I'm sorry I'm not very good at this. Is this right?
SELECT [Orchardinfo].[Method] FROM Orchardinfo WHERE (((Orchardinfo.Commodity)=Forms!RecomendationMaker ![cmbOrchard] And [cmbCommodity]=Forms!RecomendationMaker!cmbCommodity)) GROUP BY [Orchardinfo].[Method];

[CRobledo]

Nevermind I got it! SELECT [Orchardinfo].[Method] FROM Orchardinfo WHERE (((Orchardinfo.Orchard)=Forms!RecomendationMaker!c mbOrchard And [Orchardinfo.Commodity]=Forms!RecomendationMaker!cmbCommodity)) GROUP BY [Orchardinfo].[Method];

thank you!