Hi Everyone I am Diane new to this site and hope it can help me and maybe I can help someone.

[diane3686]

I would like to ask if anyone has the easiest solution to the following:
I have yes/no field approx 6 if anyone of this are checked, I do not want the related record to be visible eg Record_Delete, Record_ITTREd, Record_Archive, Record_Closed etc if any of these boxes ticked do not show the record to which they relate, rather than have to say do not show this field or this field, just the whole record please. Especially for when I print a report and I do not want these to show. Thank you.

 

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

 

[NauticalGent]

Welcome aboard!

 

[Gasman]

I would like to ask if anyone has the easiest solution to the following:
I have yes/no field approx 6 if anyone of this are checked, I do not want the related record to be visible eg Record_Delete, Record_ITTREd, Record_Archive, Record_Closed etc if any of these boxes ticked do not show the record to which they relate, rather than have to say do not show this field or this field, just the whole record please. Especially for when I print a report and I do not want these to show. Thank you.

How are you meant to get them back?
If the checkboxes are bound, just requery the form or it's recordset and exclude those records whose fields are true.

 

[theDBguy]

Hi. Welcome to AWF!

 

[theDBguy]

"Normally," you can just use one field to represent the six checkboxes,especially if only one checkbox will apply at a time. You could then use a criteria in a query to exclude those records from your form.

 

[jdraw]

Welcome to AWF! Diane.
Regarding your question, I think we need more info. Perhaps an example showing what exists and what's supposed to hapen, when. Also, it might be better to repost the question in the Forms section. Typically the Introductions is just that-introduction --who I am and perhaps why I'm here.
Questions and answers and dialog are in the various forums.

 

[Mike Krailo]

I have yes/no field approx 6 if anyone of this are checked, I do not want the related record to be visible eg Record_Delete, Record_ITTREd, Record_Archive, Record_Closed etc if any of these boxes ticked do not show the record to which they relate, rather than have to say do not show this field or this field, just the whole record please. Especially for when I print a report and I do not want these to show. Thank you.

How is the related record shown on the form? Are we talking about a subform? Are the yes/no fields bound to a table or are they unbound? In a case like this a sample database would be most helpful in getting to your solution since context is everything.

 

[pbaldy]

Welcome! FYI, I've moved your thread to a more appropriate forum.