Converting [Form] Controls to SQL

  • Thread starter Thread starter Colin Campbell
  • Start date Start date
C

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
 
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
 
Back
Top