Refer to columnn in source but not on form?

  • Thread starter Thread starter Ryan
  • Start date Start date
R

Ryan

In an event procedure, can I reference a column that is in
my recordsource but does not appear on the form? If so,
how?
 
An easy way is to put it on the form and make it's visible
property false. You can make it very tiny and even on top of
another control if you are crunched for room.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
In an event procedure, can I reference a column that is in
my recordsource but does not appear on the form? If so,
how?
Click to expand...
Sure. Me.mycolumn
But, what is it that you need to do with the information?

- Jim
 
It is an autonumber primary key I need to use in a DCount
function call in order to check the presence of records in
another table.
-----Original Message-----
Click to expand...
 
Ryan said:
In an event procedure, can I reference a column that is in
my recordsource but does not appear on the form? If so,
how?
Click to expand...

Forms have no problem with this, but Reports do. I just add a control for
Reports that is not visible, but I don't think there's any advantage/reason
to do that with a Form.
 
OK, then you might use it along the lines of ...

DCount("*", "tblOtherTable", "FK=" & Me.PKColumn)

Of course use your object names.

- Jim

It is an autonumber primary key I need to use in a DCount
function call in order to check the presence of records in
another table.
Click to expand...
 
Back
Top