Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / April 2008

Tip: Looking for answers? Try searching our database.

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

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.
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.