Link to home
Start Free TrialLog in
Avatar of Ursino
Ursino

asked on

Access Visual basic Statement in statement How To

Microsoft Access Visual Basic 2007

I have this:

S2 = "[" & Me.Select1 & "]"
 
Forms!main.Form!Data.S2.ColumnHidden = False


Notice, i'm trying to use the S2 in the second statement.

But this won't work, can someone please provide a suggestion about how to go about this?
Avatar of Flyster
Flyster
Flag of United States of America image

Did you try it without the &'s?

S2 = "[Me.Select1]"

Flyster
ASKER CERTIFIED SOLUTION
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ursino
Ursino

ASKER

This worked like a charm, all assumptions made were correct.
glad I could help.