Set Parameters for stored procedure

[digs]

I'm running a access 2000 adp front end working from a SQL2000 database. I've got a sproc P_insertsessions i can get this work from a cmd button on a form but i'm having problems setting the paramerters i want it to use controls on the form.
@contractid = contractid
@start_date = startdate
@end_date = enddate
@hours = duration

Can anyone help.

 

[boblarson]

I'm not that good in SQL Server, but I've run across a similar issue sometimes in the Access realm, I would say make sure that your controls that you are referring to for the values are not named exactly the same as your fields and make sure to reference the controls and not the fields.