Combo List Box & Parameter

  • Thread starter Thread starter Alain
  • Start date Start date
A

Alain

How can I directly include in the "contend" of a combo list box property
such a query ?

SELECT ...
WHERE ([Adresses].[RéfAdresse]) = @RéfAdresse))
ORDER BY ...

The problem is regarding the declaration of my Parameter @RéfAdresse : What
shoul I do ?

best regards

Alain
 
Witaj Alain,
W Twoim li¶cie datowanym 22 czerwca 2004 (12:47:14) mo¿na przeczytaæ:

A> How can I directly include in the "contend" of a combo list box property
A> such a query ?

A> SELECT ...
A> WHERE ([Adresses].[RéfAdresse]) = @RéfAdresse))
A> ORDER BY ...

A> The problem is regarding the declaration of my Parameter @RéfAdresse : What
A> shoul I do ?

mycombobox.rowsource = "exec dbo.mystoredproceudrename
@parameter1='" & forms!myform!mycontrol & "',@parameter2 = " &
forms!myform!mynumbercontrol

Regards
Jacek Segit
 
Back
Top