Hello there
I've got a problem with some code that I'm trying to write behind a button. All it will eventually do is just transfer the values from some text fields into a table...
Dim rst As Recordset
Set rst = CurrentDb.OpenRecordset("select * from tblProjects")
When I click the button it gets stuck on the SET RST line... with an error 13 - type mis-match.
I haven't got a clue why it's not working; the exact same code behind another button (with a different table name) works fine.
Any suggestions?
Cheers
I've got a problem with some code that I'm trying to write behind a button. All it will eventually do is just transfer the values from some text fields into a table...
Dim rst As Recordset
Set rst = CurrentDb.OpenRecordset("select * from tblProjects")
When I click the button it gets stuck on the SET RST line... with an error 13 - type mis-match.
I haven't got a clue why it's not working; the exact same code behind another button (with a different table name) works fine.
Any suggestions?
Cheers