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!!!
Click to expand...

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!!!
Click to expand...

Move the ComboBox from the details section to the form header.
Click to expand...
 
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!!!
Click to expand...

Move the ComboBox from the details section to the form header.
Click to expand...
 
Back
Top