pass a string value to a variable

E

Eric

Hi Renee,

Within the OnCurrent method of the form:
------------------
Dim strSomeVariable As String

'You could just directly refference this object in the
'If statement.
strSomeVariable = Me.txtDistrict

If strSomeVariable = "suspend" then
Me.cmdSomeButton.Enabled = False
Else
Me.cmdSomeButton.Enabled = True
EndIf
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
VBA - exporting serial letters to single documents 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
VBA word change keys 0
Changing Bound Text Box Border Width Property Screws Up Tab Order 0
How use the GlueTo Method with 2D Shapes 0
Some trouble assigning a string to a variable 22
How to Change criteria on a saved query using VBA 0

Top