<div>
slight correction from jim's post<br />
<br />
docmd.OpenForm &quot;Your popup form&quot;, acNormal,,,,acDialog, OpenArgs:=Me.Ref_Num<br />
<br />
... then in your popup form's Open event, write code like this ...<br />
<br />
If Len(Nz(Me.OpenArgs, &quot;&quot;)) &gt;&nbsp;0 then <br />
&nbsp; &nbsp;Me.Filter = &quot;Ref_Num=&quot; &amp;&nbsp;Me.OpenArgs<br />
&nbsp; &nbsp;Me.FilterOn = True<br />
Else<br />
&nbsp; &nbsp;'No filter ID was passed. &nbsp;Bail. <br />
&nbsp; &nbsp;cancel = true<br />
end if<br />

</div>


slight correction from jim's post

docmd.OpenForm "Your popup form", acNormal,,,,acDialog, OpenArgs:=Me.Ref_Num

... then in your popup form's Open event, write code like this ...

If Len(Nz(Me.OpenArgs, "")) > 0 then
   Me.Filter = "Ref_Num=" & Me.OpenArgs
   Me.FilterOn = True
Else
   'No filter ID was passed.  Bail.
   cancel = true
end if


<div>
Worked like a charm...thanks!<br />

</div>


<div>
Thanks for the grade. &nbsp;Good luck with your project. &nbsp;-Jim
</div>


Thanks for the grade.  Good luck with your project.  -Jim

<div>
<div class="content wysiwyg-content">
I have a continuous form that has a unique ID (let's call it Ref_num) for each row displayed. I want the user to be able to click a command button next to the row that will open a pop-up form with detail data related to the Ref_num. Can this be done?
</div>
</div>


I have a continuous form that has a unique ID (let's call it Ref_num) for each row displayed. I want the user to be able to click a command button next to the row that will open a pop-up form with detail data related to the Ref_num. Can this be done?

Open pop-up form from id on continuous form

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.