Prev: Subforms limitation
Next: Graph displaying dates alphabetically on x axis, not by date
From: Lori on 23 Apr 2010 12:05
Fabulous! See? - so easy, but I just didn't know where to put that information! Thanks a lot.

Also, I guess I shouldn't have included the row source information because that's defined in the VB code anyway, and it's dependent on what I put in the first combo box (I had 178 in the first box when I copied the row source information). Anyway, your solution is perfect - thanks so much ... slowly, slowly learning!



KARL DEWEY wrote:

The SQL needs to include the other two column names.
22-Apr-10

The SQL needs to include the other two column names.
SELECT capture_id, NameCol2, NameCol3 FROM dtGPSDataNew WHERE capture_id =
178 ORDER BY date_gps;

This SQL statement has criteria to olny select capture_id = 178, so how can
you really use it?

--
Build a little, test a little.


"Lori Robinson" wrote:

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Excel 2007 Filter Tool
http://www.eggheadcafe.com/tutorials/aspnet/ae703d26-58da-423a-a2cb-1f3a46fbea8f/excel-2007-filter-tool.aspx
 | 
Pages: 1
Prev: Subforms limitation
Next: Graph displaying dates alphabetically on x axis, not by date