And and Or selection

[Amen]

Have 2 values in my combo box if i select those 2 values it will skip the next step and move to the other one...



here is my code, i write this but i got an error

Private Sub womanFacility_AfterUpdate()
 If Me.womanFacility = "No" And"No info" Then
 Me.Case4.Visible = False
  
 Else
 Me.Case4.Visible = True

 
End If

End Sub

the error is in bold how can i correct that

thanks in advance

[Dal Jeanis]

Assuming that "no" is Item 2 and "No info" is Item 3 in the list, It's roughly like

IF Me.womanFacility.Selected(2) AND Me.womanFacility.Selected(3) Then

http://social.msdn.microsoft.com/For...orum=accessdev

You can also loop through all the values looking for the ones you want
http://stackoverflow.com/questions/1...elect-all-none

[Amen]

hi Dal Jeanis

cant i did this..i did but got an error...but when i did the one you, told there is no changes..
IF Me.womanFacility.Selected="No" AND Me.womanFacility.Selected"No info" Then

can you share some lights here especially the value 2 and 3

Many thanks

[ItsMe]

How are you selecting two values in a combobox? Is this a class / school assignment?

Never mind, it is a cross post

[akhmadahdiyat]

yeah.. we can't select 2 values in combobox.. I think you means is checkbox..

[Dal Jeanis]

I was assuming a multi-select combo box, to make sense of the question.

[ItsMe]

I was assuming a multi-select combo box, to make sense of the question.

Well, that is something I am unfamiliar with. I will have to go learn about it.

[Dal Jeanis]

It's not much used. One of those cool features that creates real syntax issues. In the underlying reality, the single field represents a hidden table.

[ItsMe]

It's not much used. One of those cool features that creates real syntax issues. In the underlying reality, the single field represents a hidden table.

I believe I am starting to have flashbacks of suppressed memories... the agony....