Getting values in a real time

Hi:
I try to get the value in a real time. There are two subforms inside a mainform. First user enters value into mainform. Than comes to subform1. And after that on the basis of a choice in subform1, the 2nd subform is open. In 2nd subform i create a listbox with that query.

SELECT [tbl_Events].[PPVVOD_Outlet] FROM tbl_Events WHERE [tbl_Events].[ticketnum]=[Forms]![tbl_PPVResearch]![ticketnum];

But it shows empty. [tbl_Events].[PPVVOD_Outlet] is a subform1

Hi mustish1,
SubForms do not appear in the Forms collection. You must reference them through the MainForm.
Forms!MainForm!SubFormControl.FORM.ControlName