Stuck on filter, help Please

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Golfinray - 11 Apr 2008 21:01 GMT

I was struggling with form filters by selection and Klatuu (Dave) helped me
with this one and it works great.
me.filter = "[district_name_long] = """ & me.combo & """"
me.filteron = true
My problem is, on one form (out of about 10) one field has no district name.
In other words I'm looking up facilities funding and a couple of districts
have none planned. If a user clicks on that district with the combo box
filter, the screen goes blank. Help! Thanks so much!!!

Reply to this Message

Wolfgang Kais - 11 Apr 2008 21:24 GMT

Hello "Golfinray".

> I was struggling with form filters by selection and Klatuu (Dave)
> helped me with this one and it works great.
[quoted text clipped - 5 lines]
> district with the combo box filter, the screen goes blank.
> Help! Thanks so much!!!

Move the ComboBox from the details section to the form header.

Signature

Regards,
Wolfgang

Reply to this Message

Golfinray - 11 Apr 2008 21:33 GMT

That didn't work. Thanks

> Hello "Golfinray".
>
[quoted text clipped - 9 lines]
>
> Move the ComboBox from the details section to the form header.

Reply to this Message

Golfinray - 11 Apr 2008 21:36 GMT

So Sorry, It did work, I screwed it up the first time. Thanks, so much!!!

> Hello "Golfinray".
>
[quoted text clipped - 9 lines]
>
> Move the ComboBox from the details section to the form header.

Reply to this Message