pass TextBox value to variable within SUB

Question

I have a form (named DateForm) that contains a textbox (named txt_AsOfDate), which displays a date value.

I have a separate SUB which has the following code:

Sub Test()


    Dim AsOfDate As String
    AsOfDate = txt_AsOfDate.Text

    MsgBox (AsOfDate)

End Sub

When running it, I get the following error:

Run-time error '424': Object required

What is going on? I tried loading the DateForm at the beginning of the SUB, and also tried assigning the value by further defining the object schema like below, but no luck. What am I doing wrong?

AsOfDate = DateForm.txt_AsOfDate.Value

There must be something missing here. It works for me. What line does the error get thrown on? — rory.ap
– rory.ap, Commented Nov 12, 2013 at 21:33
@roryap - It is getting thrown on this line: AsOfDate = txt_AsOfDate.Text. I want to mention that the textbox is getting populated by a query running against one of the tables in the Access solution. — sion_corn
– sion_corn, Commented Nov 12, 2013 at 21:39

Blackhawk · Accepted Answer · 2013-11-12 21:43:38Z

2

Try replacing txt_AsOfDate.Text with Form_DateForm.txt_AsOfDate.Text. Referring to a control directly in code by its name only works in the form, whereas I'm guessing this code is in a separate module.

In order to catch things like this, add Option Explicit to the top of your code modules. This forces the compiler to notify you if there is a variable being used which wasn't first declared with Dim.

answered Nov 12, 2013 at 21:43

Blackhawk

6,1804 gold badges31 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

pass TextBox value to variable within SUB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related