tabs

[sadie]

I have a form with a lot of drop down boxes...now I want to add a second page to the form
How do I do that without having to create a whole new form

 

[Mile-O]

You would generally make the tab control first and then place the comboboxes on to it in order to bind them to it.

The ones that you've created thus far won't bind to it...

...but...

...why do you have so many combos on your form? Having loads is a sign that your table is suffering from some poor quality design.

 

[maxmangion]

...why do you have so many combos on your form? Having loads is a sign that your table is suffering from some poor quality design.

why do you think that having several combo boxes in a form is a bad sign of poor design ? And when you say "many" what is the amount in numbers you have in mind ?

 

[Mile-O]

why do you think that having several combo boxes in a form is a bad sign of poor design ?

When someone says they have "a lot of" anything being displayed in a form then I immediately guess that they are basing all these controls on a repeating group in a table: (e.g. Hobby1, Hobb2, Hobby3, Hobbyn)

And when you say "many" what is the amount in numbers you have in mind ?

As many as the repeating group uses.

 

[sadie]

tabbed form

The drop downs are demographic choices for the clients when I enter data...for example "county"," referral source"
The choices remain the same for each client and it's easier for the person entering the data to be correct

I guess I'll have to re do it if I can't add a tab

 

[maxmangion]

When someone says they have "a lot of" anything being displayed in a form then I immediately guess that they are basing all these controls on a repeating group in a table: (e.g. Hobby1, Hobb2, Hobby3, Hobbyn)

In such circumstance i agree with you! the reason why i asked you that question is because i do have a form which has several combos, however, they are not from repeating groups but each hold different kind of information. The reason why i prefer to use combos rather than textboxes is so that i can avoid a lot of typing with them.

e.g. in one of my databases i keep info about my stamps, therefore on the main form i have combos for:

continent
country
printingmethod
watermark
condition
status
etc

As you see they all hold different type of information but since i have several combos in this form, i was afraid that the design is poor! You know when adding new record in the printingmethod field typing "L" and get "Lithography" is really great!

 

[sadie]

Another question
Is it possible to add a tab once a for is created without any drop down boxes, since the form is already designedthe way I want it

 

[Rich]

e.g. in one of my databases i keep info about my stamps, therefore on the main form i have combos for:

continent
country
printingmethod
watermark
condition
status
etc

the problem with having many combos on the form is one of speed opening the form.
If you have too many with their sql statements the form will be slow to load.

 

[maxmangion]

the problem with having many combos on the form is one of speed opening the form.
If you have too many with their sql statements the form will be slow to load.

Does it matter on how many records there are in the form too ? because since now i have about 2000 records in the form and i haven't noticed any lack of performance yet. Also most of the combos which i mentioned gets their values for lookup tables, and i find them useful so that i can use the on notinlist event to add more values to the table.

 

[SforSoftware]

Another question
Is it possible to add a tab once a for is created without any drop down boxes, since the form is already designedthe way I want it

Yes it is

There are several ways:
1. Add the tabcontrol to your form, then select the controls you want to have on a tab-page, then cut (not copy) the controls, select the tabpage you want them on and paste. One problem: when cut-and-paste controls, all the event-procedures (such as 'AfterUpdate) will be disconnected from the controls. The code is still in the form's classmodule, but they're not registerd to the controls. So you should set that properties form your controls back to [event procedure]

2. Make a new form, with tab-control, and then place the 'old' form as a subform on one of the tabpages.


BTW: it doesn't matter if there are dropdown boxes on you form for this...