Value in a form field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anna - 20 Nov 2006 13:41 GMT

Hi,
I have this code and for some reason I can't get the value of the field.
What am I doing wrong?

[Forms]![frmListReleaseTrack]![ListRelease Track tbl sbfrm]![TrackNoValid]

Thanks in advance!

Anna

Reply to this Message

Rick Brandt - 20 Nov 2006 14:08 GMT

> Hi,
> I have this code and for some reason I can't get the value of the
[quoted text clipped - 6 lines]
>
> Anna

In your current syntax the third piece is referring to the subform "control" and
you need to reference the form being displayed within that.

[Forms]![frmListReleaseTrack]![ListRelease Track tbl sbfrm].Form![TrackNoValid]

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

Anna - 20 Nov 2006 14:20 GMT

I'm still not getting anything.. I even put a msgbox for that and nothing... :(

> > Hi,
> > I have this code and for some reason I can't get the value of the
[quoted text clipped - 11 lines]
>
> [Forms]![frmListReleaseTrack]![ListRelease Track tbl sbfrm].Form![TrackNoValid]

Reply to this Message

Rick Brandt - 27 Nov 2006 14:28 GMT

> I'm still not getting anything.. I even put a msgbox for that and
> nothing... :(

Just nothing or do you get an error? Try this. With your form open open a
new query. In a balnk column definition right click and choose "Build...".
When the expression builder opens you can navigate to the control in
question by going through...

Forms
Open Forms
Main Form
SubForm
ControlName

That way you are guaranteed to get back a correct reference to the control.
Then you can copy and paste that where you need it.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message