How do I open a subform's content in new window? 1

[ShannonSkipper]

In my form frmDemographics there is a subform named frmActionNotes. For each record in frmDemographics there is an action note. The subform within the form works well, but I need to be able to open the the content of the subform in a new window. I am able to open a form (named frmActionNotesFull) with the data from frmActionNotes using a command button but I don't know how to get the action notes to correspond to the current record. frmActionNotes and frmActionNotesFull data are the same - but frmActionNotesFull I want to be a modal popup window. I assume I need to put somethink in the wherecriteria section of my cmd.openform but I sadly, I have no idea how to select the current record.

Any help is greatly appreciated!

 

[PHV]

How are frmDemographics and frmActionNotes actually linked ?
Doesn't has the underlaying table of frmActionNotesFull a Foreign Key referencing the Primary Key of the underlaying table of frmDemographics ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ShannonSkipper]

Yes, the underlying table of frmActionNotesFull has a Foreign Key referending the Primary Key of frmDemographics.

 

[PHV]

What about something like this in the Click event procedure of the button?
DoCmd.OpenForm "frmActionNotesFull", , , "[Foreign Key field name]='" & Me![Primary Key control name] & "'", , acDialog
If the FK field is defined as numeric then get rid of the single quotes.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244