SQL parameter help

[Goomba79]

Hello,

I have written the following sql command...

SELECT * from tblCalibrationRegister
Where [calibration due date] <now() and description =[]

is there a way that when i have the enter parameter msgbox pop up i can have it display a dropdown list populated by the sql command...

Select Description from tblCalibrationRegister

so users can select the parameter rather than type it in?

any help will be greatly appreciated!

Thanks,

iain

 

[pr2-eugin]

In the Query this might not be possible, but you sure can base a Query from a Form that will have the Combo Box and after obtaining the result you can open the Query.. Just put a small example for you..

 

[Goomba79]

Hello,
Thanks for that i think that i will go with the form route much simpler and looks alot better too!

 

[pr2-eugin]

It sure does.. Glad I could help.. Good luck..