Parameters

[Guest]

For some odd reason I am trying to set a parameters in a query to a form.

[forms]![xxxx]![xxxx]

I seem to be linking it to the correct form and list box, but when i go to
the form it does not want to pass the parameters.

Also, when I have a form with a subform and try to pass parameters, the form
comes out blank. I can't see any data and pass the parameters.

 

[John Vinson]

For some odd reason I am trying to set a parameters in a query to a form.

[forms]![xxxx]![xxxx]

I seem to be linking it to the correct form and list box, but when i go to
the form it does not want to pass the parameters.

Could you explain what you mean by "go to the form" and "pass the
parameters"?

If you have a parameter query referencing a (single-select) listbox in
this way, you can open the Query and see the results for the listbox
selection provided the form containing the listbox is in fact open (it
won't open it for you). Better, you can base another Form (or Report)
on the query, and put a command button on form xxxx to open this other
object.

Also, when I have a form with a subform and try to pass parameters, the form
comes out blank. I can't see any data and pass the parameters.

The syntax for referencing a control on a subform is

Forms!Mainformname!Subformcontrol.Form!Controlname

but I'm not at all sure this is what you mean.

John W. Vinson[MVP]

 

[Guest]

I mean could you, set a form up to be like a query. I want the user to
select a month then the data comes out in a subform. I know you can do that
in a report. But could you set it up in a form.

For some odd reason I am trying to set a parameters in a query to a form.

[forms]![xxxx]![xxxx]

I seem to be linking it to the correct form and list box, but when i go to
the form it does not want to pass the parameters.

Could you explain what you mean by "go to the form" and "pass the
parameters"?

If you have a parameter query referencing a (single-select) listbox in
this way, you can open the Query and see the results for the listbox
selection provided the form containing the listbox is in fact open (it
won't open it for you). Better, you can base another Form (or Report)
on the query, and put a command button on form xxxx to open this other
object.

Also, when I have a form with a subform and try to pass parameters, the form
comes out blank. I can't see any data and pass the parameters.

The syntax for referencing a control on a subform is

Forms!Mainformname!Subformcontrol.Form!Controlname

but I'm not at all sure this is what you mean.

John W. Vinson[MVP]