I have renamed the fields to get rid of the spaces ("Mgr's Name") to ("MgrsName") but I still get "Run-time error 3061 Too Few parameters. Expected 1 on the line "Set rst = dbs.OpenRecordset("Probation Details_emailing", dbOpenForwardOnly)." Yes the QUERY "Probation Details_emailing" contain these Fields that I am trying to access in my Recordset.
Any further help please!
Shep
Reply from Alex Hedley:
Can you run the Query from the navigation pane and it displays ok?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visual Basic Forum.