ComboBOX Parameter

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

Guest

(QUERY 1) CurrencyCodeLIST … Works Fine
- SQL COD
SELECT ExchangeRateLINK.CurrencyCod
FROM ExchangeRateLIN
GROUP BY ExchangeRateLINK.CurrencyCod
ORDER BY ExchangeRateLINK.CurrencyCode

- OUTPU
CurrencyCodeLIS
CurrencyCod
AE
AL
AR
AU
AZ
BA
BD
BG
BH
BN
BO
BR
BW
BY
CA
CH
CH
CN
CO
CV
CY
CZ

(FORM 1) CurrencyCodeFOR
- ComboBo
Name: Combo
Raw Source Type: Table/Quer
Raw Source: SELECT CurrencyCodeLIST.CurrencyCode FROM CurrencyCodeLIST

(QUERY 2) CurrencyCodePIC
- SQL COD
SELECT ExchangeRateTABLE.CurrencyCode, ExchangeRateTABLE.SDR_CurrencyExchangeRate, ExchangeRateTABLE.DateOfRat
FROM ExchangeRateTABL
WHERE (((ExchangeRateTABLE.CurrencyCode)=[Enter Currency Code:])
GROUP BY ExchangeRateTABLE.CurrencyCode, ExchangeRateTABLE.SDR_CurrencyExchangeRate, ExchangeRateTABLE.DateOfRate

- OUTPUT when typing AED as the Query [PARAMETER
CurrencyCodePIC
CurrencyCode SDR_CurrencyExchangeRate DateOfRat
AED 5.05005 22/08/200
AED 5.13047 23/07/200
AED 5.20684 23/09/200
AED 5.27688 23/10/200
AED 5.30062 21/11/200

NOW â€
I want to chose a value from the ComboBox in (FORM 1) to be set as my [PARAMETER] in (QUERY 2
Then, click on “some button†in (FORM 1) to have it output the result of (Query 2

any help will do ..
AHMADiTo
 
Are the results to be seen on the same form as the combo
box or another form?

Gerald Stanley MCSD
-----Original Message-----
(QUERY 1) CurrencyCodeLIST â?¦ Works Fine !
- SQL CODE
SELECT ExchangeRateLINK.CurrencyCode
FROM ExchangeRateLINK
GROUP BY ExchangeRateLINK.CurrencyCode
ORDER BY ExchangeRateLINK.CurrencyCode;

- OUTPUT
CurrencyCodeLIST
CurrencyCode
AED
ALL
ARS
AUD
AZM
BAM
BDT
BGN
BHD
BND
BOB
BRL
BWP
BYR
CAD
CHF
CHP
CNY
COP
CVE
CYP
CZK


(FORM 1) CurrencyCodeFORM
- ComboBox
Name: Combo1
Raw Source Type: Table/Query
Raw Source: SELECT CurrencyCodeLIST.CurrencyCode FROM CurrencyCodeLIST;


(QUERY 2) CurrencyCodePICK
- SQL CODE
SELECT ExchangeRateTABLE.CurrencyCode,
Click to expand...
ExchangeRateTABLE.SDR_CurrencyExchangeRate,
ExchangeRateTABLE.DateOfRate
FROM ExchangeRateTABLE
WHERE (((ExchangeRateTABLE.CurrencyCode)=[Enter Currency Code:]))
GROUP BY ExchangeRateTABLE.CurrencyCode,
Click to expand...
ExchangeRateTABLE.SDR_CurrencyExchangeRate,
ExchangeRateTABLE.DateOfRate;
- OUTPUT when typing AED as the Query [PARAMETER]
CurrencyCodePICK
CurrencyCode SDR_CurrencyExchangeRate DateOfRate
AED 5.05005 22/08/2003
AED 5.13047 23/07/2003
AED 5.20684 23/09/2003
AED 5.27688 23/10/2003
AED 5.30062 21/11/2003


NOW â?¦
I want to chose a value from the ComboBox in (FORM 1) to
Click to expand...
be set as my [PARAMETER] in (QUERY 2)
 
Back
Top