Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using a Variable for a Field Name
Thank you both for your help. I was able to get the code to work! Again, thanks!- mclpar
- Post #8
- Forum: Microsoft: Access Modules (VBA Coding)
-
Using a Variable for a Field Name
Thanks for the reply. strFieldName is a variable name. I did try the code strFieldText = rstStudentData(Me(strFieldName)) and now the error message says "Run-time error '2465': Microsoft Access can't find the field 'Parole Officer' referred to in you expression". So, at least it is...- mclpar
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Using a Variable for a Field Name
I tried the following code: [ strFieldText = rstStudentData(Me![strFieldName]) ] and now I get the following error message: "Run-time error '2465': Microsoft Access can't find the field "strFieldName" referred to in you expression". It looks like Access still thinks strFieldName is the...- mclpar
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Using a Variable for a Field Name
Using Access 2000, what is the correct syntax for using a variable to reference a field name when trying to read/write text in that particular field in a DAO recordset? For example, the code [ strData = rstSample![My Field] ] returns the contents of field [My Field] from recordset Sample...- mclpar
- Thread
- Replies: 7
- Forum: Microsoft: Access Modules (VBA Coding)
