Thread: Getting values in a real time
09-17-06, 12:22 #1Registered User
- Join Date
- Jul 2006
Unanswered: Getting values in a real time
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
09-17-06, 14:27 #2Moderator
- Join Date
- Dec 2004
- Madison, WI
Are there any values which show up when you run the listbox query itself? How many records are returned when you go to design view of the 2nd form and look at the rowsource of the listbox (selecting it ... and running it)? I'm not sure if you need the ; or not but don't think that would make a difference. Either that or it could possibly be a column width set to 0.
Is SELECT [tbl_Events].[PPVVOD_Outlet] FROM tbl_Events WHERE [tbl_Events].[ticketnum]=[Forms]![tbl_PPVResearch]![ticketnum];
a snapshot of the code for the listbox? If so, is the bound column set correctly?
Last edited by pkstormy; 09-17-06 at 14:32.Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)