Querying a combo box on a form in an ADP

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: DanNeedsHelp (DanNeedsHelp_at_discussions.microsoft.com)
Date: 03/03/05


Date: Thu, 3 Mar 2005 07:27:05 -0800

Hello everyone!

I need to create a query that will filter the contents of a table by
comparing a column in the table to a combo box on a form within the Access
Data Project. I have done this ad nauseum within a standard Access database,
but not in an ADP. How would I formulate the equation using these variables?

Form name = Home
Combo Box name = CB_City
Table name = factory_list
Column name = city

Thanks!

Dan