VB code in a Text Box? 1

[Hanss]

I have a form with two text boxes named

"text1" and "where"

This code will put "2" in "text1":

me.text1 = 2

Question: How can I do this?

Type "me.text1" into the "where" box and VB puts "2" in the "text1" box, not the "where" box.

Many Thanks!
Hanss
Zürich

 

[PWise]

if you would just type in the where box

text1

you can run this

me(cstr(me.where))=2

 

[Hanss]

THANK YOU! This works! Just one more question: What should I type in the box if *text1" is on another form?

For example if "text1" was on a form called "form2"

If I type:

Forms![form2]![text1]

into the "where" box I get an error saying that the field cannot be found.

Many Thanks!
Hanss

 

[Hanss]

I managed to figure out the answer myself. Simply put the form info where you have the "me".

Many Thanks!
Hanss

 

[missinglinq]

Also note that Where is a Reserved Word in Accesss and should be avoided as an object name.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!