Recent content by Kblack

Okay -- the sub-elements are those boxed off in RED. The main element is the highlighted one. What I want to do (to ensure data accuracy) is to use the sub-element ListBox selections (choices N/A, No, Yes) to determine what would populate in the main element field. If NO appears at all in the...

I'm sorry for the confusion! I have not created my form yet. I'm still working on the table that I will use to create my form. I want to make sure that I get the table set up properly before the form is created.

Yes - if any of that element's sub-elements show NO.

Okay, I hope I can successfully communicate what I need help with. I have a form with list boxes to indicate if a metric element is MET (compliant) - choices are N/A, NO, and YES. One of the elements has nine sub-elements. All sub-elements must be MET (YES) for the main element to be...

Hi, I am Kim Black and I work as a Data Analyst in Healthcare. I am responsible for creating databases for data collection and the only tools I am allowed to use are MS products like Excel and Access. I really enjoy creating tools our team can use. :)