Firstly how do I put SQL commands into my code on vb, I'm trying to get it so that in my drop down menu when the form loads it only loads distinct entries for example if you had a gender field, you wouldn't want it to keep loading male, male, female, male, female etc. which happens if you use this code.
cboCuGender.AddItem rs.Fields("Gender") & ""
you would need an SQL statement something like
SELECT DISTINCT (Gender) FROM tblCustomer;
Also I'm using ADO to connect to my database. I was wondering how the following scenario would be possible.
I have one drop down menu with categories when I select one of the categories, a different drop down menu is enabled where I can then select only items in that category.
If this isn't clear enough I'll try to clarify, just post below.
Thank you all for your help, I really appreciate it