Stuck on filter, help Please

G

Golfinray

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!!!
 
W

Wolfgang Kais

Hello "Golfinray".

Golfinray said:
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!!!

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

Golfinray

That didn't work. Thanks

Wolfgang Kais said:
Hello "Golfinray".

Golfinray said:
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!!!

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

Golfinray

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

Wolfgang Kais said:
Hello "Golfinray".

Golfinray said:
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!!!

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form Filter question 1
Isnull with a filter problem 4
Dirk Goldgar help please!!! 2
Filter help 1
Combo Box Filter 1
filter form by table 10
Remove Filter 2
Form Filtering Help 8

Top