Just figured it out... thanks much
"Allen Browne" wrote in message
...
Try:
Dim MyTable As DAO.Recordset
Multiple libraries have a Recordset object. More info:
http://allenbrowne.com/ser-38.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Tom" wrote in message
...
Help,
I am not much of a programmer, but I have managed to build a fairly good
tool.
The original code was written in 2003 but upon the conversion to 2007, I
get a Type Mismatch on the following code.
Const ProductTable = "Products"
Dim MyTable As Recordset
Dim MyDB As Database
Dim PNHolder As String
Set MyDB = CurrentDb()
Set MyTable = MyDB.OpenRecordset(ProductTable) ---ß Error appears
here??