parameter query in formulars

  • Thread starter Thread starter Matthias Reichelsdorfer
  • Start date Start date
M

Matthias Reichelsdorfer

Hi,

I have got some problems with parameter queries and how to
bind them to an combo box of a formular.

I've got following querry:

SELECT Tab_Enum.EnumString
FROM Tab_Enum INNER JOIN Tab_String_Param ON
Tab_Enum.ParamID = Tab_String_Param.ParamID
WHERE (((Tab_String_Param.ParamString)=[Param]));

If I enter a value for [param] I get a list of
enumerations.

In the property "Row Source" of the Combo Box I want to
use this querry, so I get all selectable enumerations of
this Combo Box.

Is there any way to deliver the parameter of this query in
the property field?

Thanks

Matthias
 
Off the top of my head, I believe you will need to create a text field on
the form (let's call it TXTPARAMETER) and then use that text control in your
sql string.

Modify the sql so that [Param] is changed to: Forms![... name of
form...]!txtParameter

HTH

--

Rob

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Problems with your database? Need to upgrade your application?
Contact the FMS Professional Solutions Group: www.fmsinc.com/consulting

Need a Book Recommendation?
www.fmsinc.com/toplevel/books.htm

Need software tools for Access, VB or .NET?
http://www.fmsinc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Well, this doesn't work if you wanna use the query with
different forms and more then one ComboBox in each form.

Isn't there any other way to call the query together with
a value for each parameter?


-----Original Message-----
Off the top of my head, I believe you will need to create a text field on
the form (let's call it TXTPARAMETER) and then use that text control in your
sql string.

Modify the sql so that [Param] is changed to: Forms![... name of
form...]!txtParameter

HTH

--

Rob

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Problems with your database? Need to upgrade your application?
Contact the FMS Professional Solutions Group: www.fmsinc.com/consulting

Need a Book Recommendation?
www.fmsinc.com/toplevel/books.htm

Need software tools for Access, VB or .NET?
http://www.fmsinc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-



"Matthias Reichelsdorfer"
Hi,

I have got some problems with parameter queries and how to
bind them to an combo box of a formular.

I've got following querry:

SELECT Tab_Enum.EnumString
FROM Tab_Enum INNER JOIN Tab_String_Param ON
Tab_Enum.ParamID = Tab_String_Param.ParamID
WHERE (((Tab_String_Param.ParamString)=[Param]));

If I enter a value for [param] I get a list of
enumerations.

In the property "Row Source" of the Combo Box I want to
use this querry, so I get all selectable enumerations of
this Combo Box.

Is there any way to deliver the parameter of this query in
the property field?

Thanks

Matthias
Click to expand...


.
Click to expand...
 
Back
Top