By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,827 Members | 2,220 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,827 IT Pros & Developers. It's quick & easy.

How to hide/reveal extended parts of a form based on contents of another field

P: 1
Hi everyone, it's nice to see you all and I look forward to contributing to the community.

I do have a question that I am wondering if any of you can point me in the right direction. I have been searching for some time but unable to find anything.

I am building a database for our manufacturing company and I have a form based on queries for people to use to input data. For example, if there is a problem with a product we wish to record the defects on a form in a row of information fields. If there is an additional problem with the product we would like to be able extend the form to reveal a new row of empty fields to fill out.

If we only need one incident to fill out, we want the other rows to be hidden.

My question isn't on the relationships, I have no problem there, but just how to hide those subsequent rows if they are not needed.

Caption "hidden area unless needed (maybe a checked box reveals it?)"

Any ideas guys?

Attached Images
File Type: jpg database.jpg (18.6 KB, 790 views)
Feb 23 '10 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 1,134
If I understand you correctly

Is Position2 a frame control with the other controls as children of it?
so that if you move the frame then all the other controls move with it?

If so then you can use
FrameName.visible=false to hide the frame and all its children
FrameName.visible=true to show the frame and all its children

in an appropriate event and based on some simple checks
Feb 25 '10 #2

Expert 100+
P: 1,134
Or do you mean one product with multiple sets of problem details.
one table for the product and one table for the problems.

that would be a form/subform combination
the form for the product details and the subform for the problem details
each new problem means you just move to a new record in the subform and enter the details.
One product record ... many problem records
Feb 25 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.