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