Query on Form to a control

[Victoria]

I have a form that opens a datasheet query of all records.
I would like to have a box that would, as the user moves
from 1 record to the next in the datasheet, reflect a
field's contents on the current record selected. The field
is called Batch. I will then have a button that can run a
detail report on the field selected [showing in the box].

Or, is the another easier way?

 

[Dirk Goldgar]

I have a form that opens a datasheet query of all records.
I would like to have a box that would, as the user moves
from 1 record to the next in the datasheet, reflect a
field's contents on the current record selected. The field
is called Batch. I will then have a button that can run a
detail report on the field selected [showing in the box].

Or, is the another easier way?

I'm not sure what you mean when you say the form "opens a datasheet
query". Do you mean the query is the form's recordsource -- that is,
it's the form itself that is the datasheet -- or that you open the query
as a separate datasheet? It would be pretty easy to get the former to
do what you want. The latter would be more difficult.