Querying a combo box on a form in an ADP

[DanNeedsHelp]

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

 

[MGFoster]

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

In .adp files I've found that I had to dynamically change the SQL
statement in the ComboBox's RowSource property from the AfterUpdate
event of which ever control applied. Use VBA to do this. After you set
up the SQL just pop it into the ComboBox's RowSource property. That
will cause the ComboBox to Requery & the new data will show the next
time some one looks at the drop-down list.