How do you reference the value in a text box

[AshikHusein]

Hello,

I am getting back to Access VBA programming after almost 4 years and just cant remember how do do some simple things.

I want to get the value of a Text Box in a form called "frm_form_welcome" and the Text Box is called "Text11". I have set it to a date format and am trying things like

val_date = Forms("frm_form_welcome").Controls("Text11") but it just does not seem to work.

Could anybody guide me as to how to reference the value in the Text Box? I am outside the form so I cant use Me. etc.

thanking you all

Regards,

 

[pbaldy]

Here's a handy reference:

http://www.mvps.org/access/forms/frm0031.htm

 

[AshikHusein]

Thanks!

That was extrememly helpful!!

 

[pbaldy]

No problem; that is a good one. I still refer to it sometimes.