In ms access query on form filter all

[Salih]

Hi,
Please open that MS access file.
I have made filter in form with combox and query running will filter in selection ,but in case i want all item in my filter, how can we do that? for more under please download that file will more clear. Thanks

 

[Jon]

Welcome to Access World! We're so happy to have you join us as a member of our community. As the most active Microsoft Access discussion forum on the internet, with posts dating back more than 20 years, we have a wealth of knowledge and experience to share with you.

We're a friendly and helpful community, so don't hesitate to ask any questions you have or share your own experiences with Access. We're here to support you and help you get the most out of this powerful database program.

To get started, we recommend reading the post linked below. It contains important information for all new users of the forum:

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We hope you have a great time participating in the discussion and learning from other Access enthusiasts. We look forward to having you around!

 

[arnelgp]

change the filter of your query to:

IIf(IsNull([Forms]![home11]![Text8]),[Nationality],[Forms]![home11]![Text8])

then you can blank the combobox and press the command button on your form.

 

[arnelgp]

here test your db.

 

[Salih]

here test your db.

Hello Amelgp,
Thanks, bro, for that was create, it works fine if do not mind if it's possible, I just noted some user will not understand when its blank it show all records can we add (All record) like first option? any other things you suggest ?

 

[Gasman]

You do need to train your users as to how it works, and/or provide documentation.?

You do not just chuck it on their computer and say 'get on with it'.

 

[GaP42]

This link is a reference to a solution for Combos and ListBoxes:
ALL Option for Combo and list boxes
Somewhat lengthy code,

 

[arnelgp]

the query now is filter using:

IIf([Forms]![home11]![Text8]="(All records)",[Nationality],[Forms]![home11]![Text8])

i change the Recordsource of the Text8 combobox, check it out.
added Load Event Macro to the form.

 

[Isaac]

Hi,
Please open that MS access file.
I have made filter in form with combox and query running will filter in selection ,but in case i want all item in my filter, how can we do that? for more under please download that file will more clear. Thanks

This forum is literally to Introduce Yourself. Please make your post in Access Forms.

 

[Salih]

the query now is filter using:

IIf([Forms]![home11]![Text8]="(All records)",[Nationality],[Forms]![home11]![Text8])

i change the Recordsource of the Text8 combobox, check it out.
added Load Event Macro to the form.

Thanks for you supporting Amelgp. My issues be sovled with your help again thanks