Thread: Set Mytable = MyDB.OpenRecordset
View Single Post
  #4  
Old March 3rd, 2010, 12:57 AM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
  
Posts: 1,017
Default Set Mytable = MyDB.OpenRecordset
Hello Tom,

ProductTable needs to be enclosed inside double quotes.

Steve



"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??