Use Loop to modify the visibility of multiple fields in a form

[jim_koug]

The time to normalize your DB is at the start.
Then if that is not possible, then ASAP. You are only going to jump through hoops like this with your current structure. You are thinking with an excel head on and not an Access one.

In reality, you should have a subform with a record for each pill taken by a patient and that record records the number, frequency etc.

Your call?

I used to make excels that did everything an access db can do, just to avoid having to deal with access... Always seemed like a big jump for me.

In the same form i have the "exams" as a subform, with a record for each one as a continuous form. I tried making pills the same way, but that continuous form is taking to much space. To "save" space from pills and show them all at once, by having them next to each other, i ended up making them as fields in the same table as the personal info.
I' l add a screenshot of my form (sorry for the greek in it). The info around the red square is the pill section.

printscreen.jpg