How do I reference a field if it isn't on the form?

[RSGinCA]

Access is driving me nuts! (There, I feel better...)

I have a form that is displaying information from a single record. However,
the record has one field which I don't want to display, but which I need to use
in adding a record on a different table.

Is there a simple way I can access that field without including it on the form
(possibly as an invisible field)?
Rick G

 

[Cheryl Fischer]

Putting a control on a form and setting its Visible property to False is an
often-used technique for making a control and its value available for other
processes but unavailable and invisible to users.

 

[Sam D]

If the field is part of your underlying query then you should be able to
just use its name in VBA events within the form. But if that was working
then I doubt you would you have posted! Maybe post some further info... The
fieldname isn't a reserved word by any chance?

HTH
Sam

 

[RSGinCA]

Oh...

It never occured to me to try something THAT simple. I assumed the name had to
be qualified in some way. It's so much fun being a beginner...

Thank you.

Subject: Re: How do I reference a field if it isn't on the form?
From: "Sam D" samdot davis at pedc dot com dot au
Date: 2/1/2004 11:35 PM Pacific Standard Time
Message-id: <#[email protected]>

If the field is part of your underlying query then you should be able to
just use its name in VBA events within the form. But if that was working
then I doubt you would you have posted! Maybe post some further info... The
fieldname isn't a reserved word by any chance?

HTH
Sam

Rick G