Refresh form record from subform selection?

[optionone]

Hi,

Wondering if it is possible to select a record in a subform and refresh the record shown on the main form? I would use a listbox and then just use me.listbox but i need the subform as a datasheet amongst other reasons for highlighting cells

The subform in question shows outstanding requests and ideally id like the user to be able to click on the record in the subform and refresh to show the details relating to that request rather than have to use other search boxes

Thanks

 

[Galaxiom]

Not totally sure I understand the problem but contemplate this and see if it makes sense.
Change the structure to two subforms.

Place a control on the mainform with the controlsource as:
=subformcontrolname.Form.somecontrol

(Where the subformcontrol is the one displaying the datasheet.)
This control will then track the current record in the datasheet.

Then in the properties of the subformcontrol displaying the single form, set LinkMasterFields as that control and LinkChildFields as the matching field in the subform.

This form then tracks the control on the mainform.