Great! That is it. Thanks!
Another question. I'm getting an Error 3061 "Too few parameters. Expected 1.
when I add a parameter to a query I'm running in a Module... my parameter is : [Forms].[FormSelectAreaMach].[txtMachine]
When I run the query in Access in the query designer, it runs fine. When I put it in my module and try to open it this way:
Set rsRecord = db.OpenRecordset(strQuery), I get Error 3060. If I take out the parameter, it runs fine???
What could be the problem?
Chris
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only