Subform to display record in Main Form

[SpiritedAway]

Hi -

I should know this but drawing a blank.

On my main form [FrmMain] - I have a subform [FrmMainSub] - (the data they display are from the same table [tblProject]

[FrmMain] is a data entry form and [FrmMainSub] is a datasheet that lists all the records associated with that project. [ProjectNumber]

The Link Master Field and The Link Child Field are all set to [ProjectNumber] - so the subform displays all the records where the project number is the same in the main data entry form [FrmMain]

But one easy thing I've forgotten how to do -

When the user clicks on a record in the datasheet [FrmMainSub] how do I get that record to show in [FrmMain]

Having to click back and forth through the data entry form to find a particular record is a nuisance - better to click on the record in the datasheet [frmMainSub] and that record displays in the Main form.

Can someone just tip me off how to do that again.

I'm using Access 2007

Thanks

Spirited Away.

 

[Galaxiom]

Set the control source of the textbox on the main form to:

= subformcontrolname.Form.controlname