Refer to columnn in source but not on form?

[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?

 

[Gary Miller]

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
________________________

 

[Jim Allensworth]

In an event procedure, can I reference a column that is in
my recordsource but does not appear on the form? If so,
how?

Sure. Me.mycolumn
But, what is it that you need to do with the information?

- Jim

 

[Ryan]

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-----

 

[Rick Brandt]

In an event procedure, can I reference a column that is in
my recordsource but does not appear on the form? If so,
how?

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.

 

[Jim Allensworth]

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.