You can assign the parameter at runtime based on a value from a control.

cmd.Parameters(0).Value = 123456

>Hi cathi
>
>Thanks fo replay,
>
>I don't know empid runtime, empid is passed by the current record which is show on screen.
>
>Thanks