Message Box

Hi

I have basic knowledge of SQL Server and Expert in MS Access

Know I want to change my Access Database into Database.
Now what i required is when I create any Procedure
then we use a condition helping keyword 'Where'

No what I required is when I execute any procedure using where clause It must open a Input Box where I put a condition

For Example
when I create a procedure like this

create Procedure prc_Demo
(
a int,
as
Select * from employee where emp_id = 'a'
)

Something like that So I want when I execute this then there must be open a box where I type emp_id then it show matching the result

How can it is possible

Thanks
Ashish

You Have to Loss Many Times to Win Single Time