Object Required?

[HandJT]

I get a run-time error message 424 object required using the following code and I'm not sure why.

rs = db.OpenRecordset("Select * " & _
"FROM Plant_Employees " & _
"WHERE Plant_Employees.[Clock#] = " & Val(Employee_Scrap.[Clock#]) & ";")


Does anybody have any suggestions on how I can change it?
Thanks in advance!!

 

[KenReay]

No Problem - did you get it to work, if yes, what was the problem?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK