P Portista New member Local time Today, 16:10 Joined Aug 2, 2006 Messages 6 Sep 19, 2006 #1 G'day, can anyone tell me how to quickly create form based queries using the design view interface. I want my users to be able to specify the various criterias using drop down menus.
G'day, can anyone tell me how to quickly create form based queries using the design view interface. I want my users to be able to specify the various criterias using drop down menus.
C cuttsy The Great Pretender Local time Today, 22:10 Joined Jun 9, 2004 Messages 164 Sep 19, 2006 #2 You can't do it quickly Add the drop down menues to your form and a button. On the button click event you build the SQL string of the query you want to run. I.e. Code: Dim sMyQuery as String sMyQuery = "SELECT * FROM MyTable WHERE YourField = " & me.mydropdown1 & ";"
You can't do it quickly Add the drop down menues to your form and a button. On the button click event you build the SQL string of the query you want to run. I.e. Code: Dim sMyQuery as String sMyQuery = "SELECT * FROM MyTable WHERE YourField = " & me.mydropdown1 & ";"
G'day, can anyone tell me how to quickly create form based queries using the design view interface. I want my users to be able to specify the various criterias using drop down menus. 
