Getting default value as a parameter in access?

[prabha_friend]

I know we can make a criteria by getting a parameter but I need to give a default value on user's prefrence. Possible in a parameter query?

 

[ranman256]

Use a form so the user can pick the option (say Employees) then the query will use that pick in the criteria and parameter.
Select * from tEmployees where [EmpID]=" & forms!frmMain!txtEmpID