Sub-Form not retaining data

[kavarin]

I have created a sub-form bound to a separate table and joined via a record number. I have created a control button on my main form that brings up the sub-form. A user inputs specific data, saves and exits the sub-form, returning to the main form. When the user then selects to go back into the sub-form for editing of info, the data is gone. The table has the stored data in it, but I am confused how to have the data come up upon entry into the sub-form. What function am I missing here?

 

[kavarin]

To add to the mix...the report number that is the joining property on the sub-form does not pull over from the main form. How can I have this sub-form open and automatically have the matching record number in the field?
Thanks for your help-

 

[Dgavilanes]

Need to link it,go to properties tab data, in design view click the upper left corner of the subfrm (by Id)
and linked it.if you need help and your db is not that big e- mail to me

 

[kavarin]

Not sure I follow ya here?
I have changed the record source for the Record# field to be the table that the MAIN form pulls from, but I still cannot get the sub-form to show the matching data based on record#. It does have the record number now, but the data will not show in the form, only the actual table
What is your email address?