Stuck on filter, help Please

  • Thread starter Thread starter Golfinray
  • Start date Start date
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!!!
 
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.
 
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.
 
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
Combo Code Help Please 3
Filter help 1
Filter tabular form by combo box 0
2 Combo Box Filter for a Form 1
Combo Box Filter 1

Back
Top