Original Post
Well 1st, /wave hey all. Im new to the world of game programming (well programming altogether) I have studied VB a bit in college but havent touched on it since (incase you are wondering, that was like 2 years ago). Anyhow, here is my question; I am currently writing a program to assist me in my job. Yea i know what your gunna say "this isnt a game." Well i had to put off the game tutorial that i was working on (from the book "Game Programming For Teens" by Jonathan S. Harbour) to get this program done. I am writing a program that will enter data to a database using a GUI made in vb. I am trying to take data from a list and send it to the database. The problem that I am having is this, i am trying to search through a list of 5 possible items using a IF ELSEIF statement. The IF statment i have worked out and seems sound to me but I need to find a character that will look for "ANY" data that is in the list. Something similar to the "*" when doing a file search in windows. So the code would look something like this: If lst1.List(4) = "*" Then With rstRecordset .AddNew .Fields(4) = lst1.List(4) .Fields(3) = lst1.List(3) .Fields(2) = lst1.List(2) .Fields(1) = lst1.List(1) End With Else If lst1.List(3) = "*" Then With rstRecordset .AddNew .Fields(3) = lst1.List(3) .Fields(2) = lst1.List(2) .Fields(1) = lst1.List(1) End With Its kind of a backwards filter (its the only way I could think to do it). Any help or advise would be greatly apriciated and pplz 4give the Noobness :-) Thanks!!!