Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to insert SQL statment to this ?
Message
General information
Forum:
Visual Basic
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00402113
Message ID:
00405619
Views:
17
>Eric,
>
>Can u give me some code Pls.?
>

You should have a command button on your form to let the user retreive data? If we take the query you had in your original question, it should be modify to look like this:
strSQL = "SELECT * FROM unit, unittype, estate" & _ 
         "WHERE untestateidno = estateid " & _
         "AND unttypeidno = unittypeid " & _
         "AND Combo1Field = '" & combo1.text & "' " & _
         "AND Combo2Field = '" & combo2.text & "' " 
>
>>>Could you please advice me how to issue the Where clause (BUT) after making the Recordset same as the code I posted above.
>>>Meaning ... After I issue the code above I open the form then the user has to select the data from 3 ComboBox, then I'll take the selected ComboBox values and make the search in the current record set and find the record matching the 3 selected values. (I think it's like firing another where clause for the current Select statment with the current Where clause).
>>>
>>>Highly appreciate it...
>>
>>Don't query your database until you have all your requirements (ie your 3 combobox filled).
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform