select record in form

[Guest]

Is there way to select a particular field for a particular record within a
form.

For instance, I have a form that's driven from a query (obviously). Based on
other criteria, I want to be able to go to the 7th record and store the value
of field "Match" to use later in the macro.

Something like DoCmd.GoToRecord acDataForm, "Match", acGoTo, 7 perhaps? (and
no, that doesn't work)

 

[Guest]

Have a second form open with a field to store the data. Set the Doublble
Click property of your orignal form call a macro to Set Value of storage form
field from the orignal form field.