subform to open form w/ active master record

[spitfire122]

i have 2 tables. ReviewData, concessions. w/ one-to-many relationship (reviewdata.ID to loan_number.concession).



the main form called concession_form has the data details.

i have a subform (that is datasheet)... in a form that has 'reviewdata'.
i want to make hyperlink in the subform that when you click (New) , it opens the concession_form. however, upon open, its not loading the relationship between the 2 tables and not writing to the record. i have a master/child relationship setup with the 2 tables... but the form that is opening, is not a subform.

how do I write a macro for this?

[June7]

This description doesn't make sense to me. Attach your project to post for analysis.