I'm working on porting an Access DB to SQL. I'm trying to decide whether to
keep my original front end mdb/mde and accessing SQL via ODBC linked tables
or use an ADP.

Anybody has any pro/cons?

One thing I have noticed is the following:
On many comboboxes, I have a row source that look like this:
   SELECT Sites.* FROM Sites WHERE Sites.Active=True Or SiteId=cmbSiteName;
where cmbSiteName is the name of the control that this query was used for
rowsource; hence returning the value for the current record for this control.

This was setup in order to be able to inactivate individual values in the
source table without affecting records that might have used that value. So
any given combobox would only display the list of active items and if the
current value was de-activated, then it would still be available for
selection.

I know I could accomplish the same by promatically setting the rowsource
during the Current event to include the value of the current record, but I
like to limit how much code runs on my current event to keep things fast and
simple.

Any suggestion on how to dynamically include a value from a control on a
form into a rowsource query for another control when using ADPs?

Thanks

Peter-d