Re: Refer to itself
- From: "'69 Camaro" <ForwardZERO_SPAM.To.69Camaro@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 30 Sep 2007 16:09:08 GMT
Hi, John.
I think I misunderstood your question. You aren't looking to hard code the
control's name. In that case, follow Allen Browne's good advice.
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
"'69 Camaro" <ForwardZERO_SPAM.To.69Camaro@xxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:5PPLi.328$0I5.63@xxxxxxxxxxx
Hi, John.
I want to refer to that field's value. What's the easiest way to refer to
that field's value?
To avoid bugs, circular references, et cetera, change the name of the
control bound to the field from the field's name (which is the default
when Access creates the bound control) to something else, such as
txtInvoiceAmount, instead of InvoiceAmount. Example VBA syntax:
variableName = Me!ControlName.Value
or
variableName = Me.ControlName.Value
st = Me (which doesn't work).
In this case, Me refers to the form itself.
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
.
- References:
- Refer to itself
- From: john
- Re: Refer to itself
- From: '69 Camaro
- Refer to itself
- Prev by Date: Re: Refer to itself
- Next by Date: Re: Database Options - Any other settings I should adjust?
- Previous by thread: Re: Refer to itself
- Index(es):
Relevant Pages
|
