Accessing calculated fields for a certain record on a form

  • Thread starter Thread starter David Walker
  • Start date Start date
D

David Walker

Hi
I've got a form which displays some records from a query (multiple tables).
For various reasons I have calculated fields mixed in with these records,
which are calculated based on walues from that record in the database.
I then run a macro, and need to move to the correct record on the form to
use one of the calculated fields - I have tried GoToRecord, but don't know
the record number, and FindRecord based on one of the values from the
database, without any luck.

How can I access a single calculated field from a form when there is one for
each record shown? I know I need to move to the correct record number, just
can't work out how to do that.

Any help greatly appreciated!

David
 
What is your criteria to move to a specific record? In other words, when
you say you "need to move to the correct record on the form" what does that
mean verbally? You need to move to a person named "Bob" or to a car colored
"Red" or ???
 
Back
Top