SQL and Using Text and Combo Boxes

SQL and Using Text and Combo Boxes

I write a statement such as

frmStatistics.datStatistics.RecordSource = "SELECT * FROM tblSpecialGroup Where Sex = 'M' AND Date BETWEEN '" & "051099" & "'" & " And " & "'" & "051499" & "'". 

This statement draws up records from my database that are Male and between the dates of 5-10-99 and 5-14-99 on an MSFlexGrid. Well, I want to enter the data from text boxes and combo boxes instead of putting the data in the code. Such as this statement:

frmStatistics.datStatistics.RecordSource = "SELECT * FROM tblSpecialGroup Where Sex = '" & Trim(cboDate(1).Text) & "'"

Well, both statements work, but what I’m having trouble with is making a statement that has a combo box for Sex and 2 text boxes for Date (so that the user can enter from 5-2-99 to 9-3-99 and so on). How do I make the statement to work with the SQL with the text boxes for date and combo box for sex? Here is my attempt (I have made many, but none of them work):

frmStatistics.datStatistics.RecordSource = "SELECT * FROM tblSpecialGroup Where Date BETWEEN '" & trim(txtdate1.Text) & "'" & " And " & "'" & trim(txtdate3.Text)& "'" & "'" AND Sex = '" & trim(cbogender.text) & "'"

Genie [email protected]

It seems to me that what is needed is a query parameter selection form part of this application; a place where the user enters in the things they are going to search for, then get them and process it.Is the datatype for sex also character or is it something like 1= male and 2 = female?

See also  How IoT Tech Will Transform Logistics

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist