vba - fields in forms

A

ACastano

Hello.
How can i read the contents of a field, in a ACCESS form, whose name is txt1
and its placed in its fifth (of 20) line.
Thanks
 
D

Daniel Pineault

1st off let get some terminology straight so we are talking about the same
things. In a table columns are referred to as fields, but in a form they are
called controls (text boxes, cmd buttons, combo boxes,....).

You can retrieve the value of any control by using the Me.FormControlName
synthax. So in your case, try something like:

Me.txt1

As fo 'its placed in its fifth (of 20) line' I don't understand what you
mean. Could you explain it again.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.com/index.php
Please rate this post using the vote buttons if it was helpful.
 
A

ACastano

First of all I thank you for your answer. I really want a control, but, in a
form that shows many records, the same field repeats in many lines. What I
want is to Know the value of the field in the fifth row. If I use "Me.txt1" I
will get the value which corresponds to the first line of the form. Did you
understand my question?
Thank you very much.
 
Top