Converting [Form] Controls to SQL

[Colin Campbell]

I make extensive use [Form]![fieldname] to get values from
combo boxes to run queries. I want to upsize the
application to SQL server but have read that .adp projects
don't support forms in this way. If I convert, how do I
access the values from the combo boxes?

Thanks, Colin

 

[Vadim Rapp]

CC> I make extensive use [Form]![fieldname] to get values from
CC> combo boxes to run queries. I want to upsize the
CC> application to SQL server but have read that .adp projects
CC> don't support forms in this way. If I convert, how do I
CC> access the values from the combo boxes?

using parameters and new property InputParameters for the form.

for example, your form is bound to

select c from t where i=form1!field1

In ADP it will be

select c from t where i=@parm1

and then in the form's InputParameters

@parm1 = form1!field1


For the rowsource of combo etc., there's no InputParameters, you'll have to
reset the rowsource in code once the referred value changes.



Vadim