Moving Subforms Based on Input

qwerty99

Registered User.
Local time
Today, 17:54
Joined
May 7, 2013
Messages
41
I'm creating a database for work, and one of my forms currently has 8 subforms on it. For each individual account there can be one, none, or many of any combination of these subforms that will have information on them. I need the form to be able to show all of them, as someone else will be inputting all the information when the database is complete, but to make it easier I have set it up with checkboxes so that when a checkbox is checked, a subform shows, if not checked it doesn't show. I have very limited skills with VBA, so that in itself was an accomplishment for me.

My questions is: is there anyway in access to do it so that if a subform doesn't show, all the ones beneath it that do show will get bumped up so that it is easier to read/input data?

If it helps I have attached my DB and the appropriate form is "ICinfoT."

Thanks for any and all help!
 

Attachments

I shouldn't be surprised. But thanks for the idea though, I'll try that out.
 

Users who are viewing this thread

Back
Top Bottom