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

  • Thread starter Thread starter RSGinCA
  • Start date Start date
R

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
 
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.
 
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
 
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
Click to expand...

Rick G
 
Back
Top