Are there any visual basic people here who could answer a quick question for me?
Re: VB people
NO
Re: VB people
Just post your question , you might get answers from some non Very Bad (VB) people.
Re: VB people
Thanks 
Re: VB people
okay for starters, is there something wrong with this statement:
If Mainswitchboard.Check150.Value = True Then
Re: VB people
PhatB, I see you started a thread in Computers also. Hope you get some answers here, otherwise we'll merge it with that thread.
Re: VB people
yes
I know i am trying to finish this by 4. Doesn't look like thats gonna happen :(
PhatB, I see you started a thread in Computers also. Hope you get some answers here, otherwise we'll merge it with that thread.
Re: VB people
post the question, someone may be able to answer it iA :)
okay for starters, is there something wrong with this statement:
If Mainswitchboard.Check150.Value = True Then
It depends...whts the data type you are using to declare Mainswitchboard
and i should small letter in If instead of having capital I.
other than i dont see any problem...and end this if properly...program should execute.
btw, wht kinda program you are trying to write..i might can help you...coz m also studying Visual basic C#
Re: VB people
Okay i am gonna try and hopefully it will make sense but i am not a vb person, this is actually my first and its getting too complicated :o
Okay this is what i am trying to do
I have a query in access that figures out particle size range then I have to take that range compare it with the one user selects(by checking a checkbox) and then show a form with the list of the paints that match the particle size they are asking for.
I have this public function
Public Function getCtrlNum() As String
Dim PZ As String
If Check158 = True Then
PZ = "4-32"
ElseIf Check150.Value = True Then
PZ = "3-20"
Else
MsgBox ("No values selected, please select a value.")
End If
getCtrlNum = PZ
End Function
And then I use this function in the query's criteria field.
Re: VB people
have you solved the issue on paper with a pencil ?
Re: VB people
OK fellas, time to mve it to Computers. Follow up there.
What if both Check150 and Check158 are True simultaneously?
Re: VB people
^ I dont know. I am not even gonna think about it. Its friday and I am done mentally for the day.
I figured it out guys 
This IT guy in NJ thinks i am a genius
I responded to your PM. The Check “chkbox.value = true” will never work. You have to use the vb enumeration called “vbChecked.” so in onther words, you have to evaluate the following statement
“If Check420.value = vbchecked”
Re: VB people
^ That actually worked. But today when I added more check boxes, its not working again :( I have to email this db out soon :(