Passing SQL string to Subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there,
I've created a form with 3 cascading controls (2 drop down lists and a multi
select list box, to be selected in that order) which will return results into
a subform on that form. It looks as though creating a SQL string is reqd iat
least because of the mutli select list box but how do I get the subform to
display that SQL string.
Thanks
Frank
 
Frank,

Do you literally mean for the SQL string to be displayed on the subform?
Or do you mean the SQL to be applied as a query, and the data
returned by the query to be shown on the subform?

If the first, you could have a label on the subform, and then in your
code, after the strSQl is built in your code, something like this...
Me.MySubform!TheLabel.Caption = strSQL

If the second, I guess you are talking about adjusting the subform's
Record Source, something like this...
Me.MySubform.Form.RecordSource = strSQL
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to always get the top level form reference, when calling from any subform/subform... 0
Regarding Subform update 1
Moving Subform to Tab Control 3
Referring to control on subform 3
Subform dependent combo box 4
filtering a form based on the values of a subform 0
filter query on combo box in a continuous subform 0
Update the subform or refresh based on multiple selection in a lis 1

Back
Top