Form Control to another form

[pablavo]

Hi folks

Ok, this one is quite simple, I just keep getting bother with it.

I have a Form with a bound txt box. I want this forms control for that record to show in another form which is a continious form

I've tried this
=Forms!frmProjectDetails!tblCommitteeDetails.Form!FundingFromDate

The FundingFromDate being the txt box that I want to show on the another from.

When I type the data into the txt box in question it gives me the same data for EVERY record on the destination "continuous" form. So if i type in 11/11/1997, all records within the Destination "continious" form will all say 11/11/1997 instead of being unique to that target forms records.

i.e.
Project1 . 11/11/1997
Project2 . 11/11/1997
Project3 . 11/11/1997

Can anyone help me

 

[Rich]

Use the Where clause of the OpenForm method or the criteria for the date field in the continuous forms underlying query