troubleshooting Question

Filter records in a forms where one or more fields are blank

Avatar of darls15
darls15 asked on
Microsoft Access
17 Comments3 Solutions133 ViewsLast Modified:
Hi Experts

I have a table [tblRegistration] which is imported into my MSAccess database from a system which has no mandatory controls. This table will be continually added to as the data is regularly exported.

To assist in cleaning up the data, I've built a form, [frmRegistration], based on the this table and it includes 7 text fields which need to be checked to ensure data exists in all fields for every record.

I need to filter the recordset to only show only those records containing any blank fields. The fields are named Response1, Response2 ... and so on.

Ultimately, I would like to filter these records using a toggle button on the form so that I can turn the filter on and off again when required.

Would anyone be able to help me accomplish this? I have searched and haven't been able to find anything that works the way I need it to.

Join our community to see this answer!
Unlock 3 Answers and 17 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 17 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros