Get values in real time

  • Thread starter Thread starter Anna
  • Start date Start date
A

Anna

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


Thanks.
 
Hi Anna,
Just answered in the ASP Free Forum.
http://forums.aspfree.com/microsoft-access-help-18/getting-values-in-a-real-time-132968.html

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

Thanks.
Click to expand...
 
Back
Top