VBA for CASE SELECT logic

[rlsublime]

I currently have the following code linked to a button on my form. I am trying to create a multi-filter. So a user could enter data in Text28 or Text33 and then click the button to run the filter. I tried to set this up with cases to say if text28 is not null then apply filter, and if it is null move on to the next case. Currently, then code is not working. Would I need to define Text28 somewhere in my code. Any idea on how to fix this? Thanks

Please Login or Register  to view this content.

[JieJenn]

I think IF statement might be easier in your case

Please Login or Register  to view this content.

[rlsublime]

I actually also have a 3rd criteria which should look at both text 39 and text 41 for values. How would i incorporate this?

Please Login or Register  to view this content.

[JieJenn]

The same logic, but you prob would use ElseIf instead of ELSE

Please Login or Register  to view this content.

[rlsublime]

Thanks. If the value is not found in the database for any of the text fields,how would I display a message saying value not found in the database?

[JieJenn]

At the end you add

Please Login or Register  to view this content.

[rlsublime]

Do you have any idea why the bolded/underlined section in the below code is not working? For the Text 39 and Text41 filters, I am trying to get the user to enter values in both fields. The logic is already built, but I am trying to display a message if one field is entered and one is blank, prompting the user that if one is entered, the other should be entered as well for the filter to work. the logic looks correct, but not sure why it is not running. Thanks

Please Login or Register  to view this content.