Re: How to get at sub-form record number in VBA (or an expresion)?
- From: rkc <rkc@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 03 Apr 2006 10:57:17 GMT
usenet@xxxxxxxxxx wrote:
rkc <rkc@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
usenet@xxxxxxxxxx wrote:
Where is your code? If it is in the Form module that you are
referencing then Me.CurrentRecord should work. Me is just a
reference to the object the code is part of. Same as This in Java
I believe.
If it is in a stand alone module then Forms("FormB").CurrentRecord.
Me has no meaning in a stand alone module.
Getting even simpler an expression of =CurrentValue+1 as the default
value of the column gives me almost exactly what I want. I think I
can now get to what I want.
Sure. You can use CurrentValue without referencing Me since the form's
properties and methods are simply available when called from within the
form's own methods. But then someone like you comes along, sees it and has no clue where it came from or why it works. Qualifying it with Me
clears that up. Sort of.
.
- References:
- How to get at sub-form record number in VBA (or an expresion)?
- From: usenet
- Re: How to get at sub-form record number in VBA (or an expresion)?
- From: David W. Fenton
- Re: How to get at sub-form record number in VBA (or an expresion)?
- From: usenet
- Re: How to get at sub-form record number in VBA (or an expresion)?
- From: rkc
- Re: How to get at sub-form record number in VBA (or an expresion)?
- From: usenet
- Re: How to get at sub-form record number in VBA (or an expresion)?
- From: rkc
- Re: How to get at sub-form record number in VBA (or an expresion)?
- From: usenet
- How to get at sub-form record number in VBA (or an expresion)?
- Prev by Date: Re: Basic VB/Access2003 syntax, how to find out about it?
- Next by Date: Re: MAS90
- Previous by thread: Re: How to get at sub-form record number in VBA (or an expresion)?
- Next by thread: Re: How to get at sub-form record number in VBA (or an expresion)?
- Index(es):
Relevant Pages
|