Access 2007 - code no longer valid

[Stefan Hoffmann]

hi Mark,

the line:Select Case frm.txtLuminaireType no longer works

Try the bang instead of the dot:

Select Case frm!txtLuminaireType


mfG
--> stefan <--

 

[Jim C]

My solution to a similar problem was to make sure the Microsoft Access 11.0
Object Library is referenced for the running code.

Access 2007 changes the referenced library to Microsoft Access 12.0 Object
Library making code that work previous to 2007 no longer run under 2007.

It work for me anyway.

I hope that helps,

Jim

 

[Mark Kubicki]

I have code behind several forms written in earlier versions (2003 and
earlier), but are not translating into 2007.
....I recently inquired about referencing the datasource of a form (see: Re:
Access 2007 - table field references no longer valid on forms (?), 5/7/2007
10:31) (with a very useful reply...)

On, what I would assume is a related issue, i have the following lines of
code, which are
in a subroutine (GenerateDescription(Me)) called by the main form; they did
also not translate into 2007

Sub GenerateDescription(frm As Access.Form)
Select Case frm.txtLuminaireType.Value
Case Is = "downlight"
...

the line:Select Case frm.txtLuminaireType no longer works
(I am evaluating a text box: txtLuminaireType on the main form)

the calling line is: ...Call GenerateDescription(Me)


thanks in advance,
mark