Type Statement variable names
Posted on 2005-04-20
I am upgrading an existing MS-Access application to VB
I have several different record types and my thoughs were to setup each record with a type statement. I have the following questions:
1. Do the variable names in the Type Statement have to be the same as they are in the file? For example, if the MDB file the field name is "Case Number", do the field name in the TYpe statement also have to be "Case Number"?
2. If the answer to question number 1 is correct, how do you code the field name within the type statement? When I use "Case Number" I receive a compiler error. When I use [Case Number], I receive a compiler error?