Popup

[DavidMcArthur]

Hi Everyone,



I have a Multiple Items table to show people related to a specific company.

So in my form I have Company A and everyone from that company is displayed in a Subform linked to a Multiple Items table form as described above.

Is there a way I can have a link so that if you click on it another popup will show with a bit more information for that person?

[ranman256]

select the record, click a button to show detail,
if the button is on the master form , you want to reference the subform then the text box name on the subform
(use the builder to get the path correct)

if the buton is on the sub form, then its just me.txtID

'btn on master form
docmd.openform "frmDetail",,,"[empID]=" & forms!frmMaster!subForm!form!txtID

'btn on sub form
docmd.openform "frmDetail",,,"[empID]=" & me.txtID