Combo Boxes

[BDawg04]

I was wondering if you can hide a combo box and then while you are in form view have it appear. I have a form that has 15 combo boxes for one section. The section refers to a table called 'Memo Sent To'. Very rarely will I need all 15 boxes. Most of the time I will not need more than 4-5 but some records will need to show that the memo was sent to 15 people. My supervisor wants to open the form and have only 4-5 combo boxes showing but have the ability to add another combo box if the memo needs to be sent to more than 5 people. I don't know if this is possible. I know you can hide a control on a form but I don't know how you would make it visible again while being in form view. If anyone knows the answer I would love to find out.

 

[ansentry]

How to you want them to appear, e.g toggle button , command button or an event on the form.

You say that you have 15 combo boxes on your form what are they for? There maybe some other way to handle your problem.

If you are using the 15 combo's to store who got what memo then I think that you should be using a main form with a subform.

Just my penny's worth

 

[Mile-O]

If you are using the 15 combo's to store who go what memo then I think that you should be using a main form with a subform.

Yep, the database in question is not properly normalised - the instance mentioned here does not meet first normal form.

 

[BDawg04]

I have attatched a screen shot of the form. My supervisor would actually like to have all of the combo boxes set up so that they can add an additional one if needed. They mentioned possibly hitting the TAB button, or some other button on the keyboard, to open another combo box. The 'Memo Sent To' combo boxes are on the right side followed by 'Job Title' combo boxes. Each set of combo boxes has its own table with all of the information. For instance, the 'Memo Sent To' combo boxes link to a table called 'Memo Sent To' that is storing all of the names that a memo can be sent to. The same situation exist for the 'Job Title' combo boxes. Each record in the main table, called 'Action Taken Revised', can have up to 15 people the memo was sent to along with 15 job titles. I think I have explained this correctly. If you have any questions let me know and I'll try to explain in more detail or at least to the best of my ability. Thanks for the help so far.

 

[canjfn]

I agree with the poster that suggests you should use a main form and a sub form but if you are determined to keep the form as is, how about

In the On Open form properties code, you can hide the combo boxes and job fields like

Me![Combo5].Visible = False
Me![Job_Description5].Visible = False
Me![Combo6].Visible = False
Me![Job_Description6].Visible = False
Me![Combo7].Visible = False
Me![Job_Description7].Visible= False
Me![Combo8].Visible = False
Me![Job_Description8].Visible = False
Me![Combo9].Visible = False
Me![Job_Description9].Visible = False
Me![Combo10].Visible = False
Me![Job_Description10].Visible = False

Then say On Enter Combo4 properties code, put
Me![Combo5].Visible = True
Me![Job_Description5].Visible = True

Then On Enter Combo5 properties code, put
Me![Combo6].Visible = True
Me![Job_Description6].Visible = True

etc, etc so each combo box you drop into, the next becomes visible

 

[BDawg04]

Thanks for the input everyone. I really appreciate it. It seems to be working just fine. I will also try the form and subform approach and see which one my supervisor like better.