Filter Combo Box Based on Previous Combo Box Selection 2

[TonyBerry]

I have searched and searched for an answer and have found a lot of good information, but nothing to address my issue. I am a big fan of DLookup, but I don't think I can get it to do what I want in this case.

Database Layout: frmMain, frmModel, tblMain, tblModel, qryManufacturer

The first field in frmMain is bound to tblManufacturer (Dell, IBM, Cisco, etc.). These values are supplied by qryManufacturer which basically pulls all the unique fields from tblModel.Manufacturer. When selecting "Dell" in the first combo box then pressing Tab to go to the next combo box, I would like the second combo box to filter only the "Dell" items from tblModel (i.e. PE2950, PE6850, etc.).

Thanks for the help. I haven't done any Access/VBA programming in a LONG time. I'm a Network/System Administrator now, so I'm getting pretty rusty on this stuff.

 

[Mayhem9]

I thought you were searching for duplicate procedure names.

No - was trying to find out more about compile (how to do it, how often should it be done [you did answer that one], what to expect etc).