September 6, 2008 09:39pm pdt

1. capricorn1 705,737
2. boag2000 480,415
3. LSMCons... 374,630
4. DatabaseMX 336,668
5. peter57r 255,702
6. harfang 179,713
7. jimhorn 144,623
8. wiswalld 140,673
9. koutny 86,850
10. MikeToole 85,778
11. hnasr 80,644
12. eghtebas 79,977
13. GRayL 79,924
14. TextReport 76,173
15. ldunscombe 75,386
16. frankytee 74,964
17. omgang 60,422
18. LennyGray 56,432
19. irudyk 56,350
20. jefftwilley 54,970
21. mbizup 54,552
22. JDettman 53,870
23. Rick_Ric... 53,365
24. matthews... 45,897
25. JezWalters 43,325

1. capricorn1 1,193,979
2. DatabaseMX 687,881
3. LSMCons... 551,998
4. boag2000 529,505
5. peter57r 472,671
6. jefftwilley 340,037
7. harfang 322,234
8. mbizup 257,169
9. jimhorn 248,170
10. frankytee 183,205
11. wiswalld 180,887
12. GRayL 157,992
13. MikeToole 150,596
14. stevbe 146,536
15. LPurvis 119,295
16. matthews... 110,247
17. JDettman 106,070
18. eghtebas 102,222
19. koutny 97,875
20. ldunscombe 96,845
21. dqmq 87,698
22. omgang 85,757
23. hnasr 80,644
24. puppydog... 78,564
25. TextReport 76,173

05.20.2008 at 09:43AM PDT, ID: 23417919

	[x] Attachment Details

Query Based Upon Dependent Combo Boxes Won't Refresh

Asked by kmartinenko in Access Forms, Microsoft Access Database, Access Coding/Macros

Tags: Access 2007, VBA, SQL

I have a problem with a pair of combo boxes that I am trying to use to query a table based upon the selections made in said combo boxes.

route_combo selects the distinct route from table InterstopData2
timeperiod_combo selects the distinct trip from table Query2 (see code snippets below for rowsource)

Now, the dependency relies on the selection from route_combo so that the route_combo_AfterUpdate() VBA code is

Me.timeperiod_combo.Requery

The timeperiod_combo box returns a list of times specific to the route selected in route_combo

*This Works Perfectly*
==================

Now, here's my problem. I created a new query (Query3) that returns all rows and fields in the InterstopData2 table that match the selections from these two combo boxes. It works perfectly for the very first selection (route 1) for route_combo, and the very first selection for timeperiod_combo (6:00 AM). But when I close out the query table and select a new route and new time, the query does not refresh, and no rows or fields are returned. See below for code snippet for said Query3

What am I missing here that is causing the query not to return data given a new selection other than the first row for each combo box?
Start Free Trial

         
             /timeperiod_combo rowsource/
SELECT DISTINCT Query2.TRIP FROM Query2 WHERE ((InterstopData2.ROUTE)=Forms!Form1!route_combo); 
/end/
 
/route_combo rowsource/
SELECT DISTINCT InterstopData2.ROUTE FROM InterstopData2; 
/end/
 
/SQL for Query3/
SELECT InterstopData2.ID, InterstopData2.ROUTE, InterstopData2.STOP, InterstopData2.TRIP, InterstopData2.DIR, InterstopData2.LOCATION, InterstopData2.[ON], InterstopData2.[OFF], InterstopData2.LOAD, InterstopData2.RIDERSHIP, InterstopData2.RUNTIME, InterstopData2.SAMPLES
FROM InterstopData2, Query2
WHERE (((InterstopData2.ROUTE)=[Forms]![Form1]![route_combo]) AND ((InterstopData2.TRIP)=[Forms]![Form1]![timeperiod_combo]));
/end/

Keywords: Query Based Upon Dependent Combo …

	Title
1	How can i refreshing combo box propo…
2	Default to First item in Combo box
3	Code a SQL statement for Rowsource …
4	Urgent rowsource combo box question
5	Can ALL properties of a "MS Graph …
6	Help with RowSource on Combo Boxes

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Query Based Upon Dependent Combo Boxes Won't Refresh

Asked by kmartinenko in Access Forms, Microsoft Access Database, Access Coding/Macros

Tags: Access 2007, VBA, SQL

About this solution