Controls for variable in main form

Question

Hi ,

My Database has a main form, which contains many controls (text box) to use as variable container which is being called from different forms and Queries.  additionally form has its own controls. 

I read it an article that main form should be light weight and it should contain minimum controls , query and sub form.  So i feel it is necessary to replace these controls with less no of controls.  

First i thought about arrays, but i can not use value of array as easily as it can be used from a form.

Can any body guide me how to manage these controls.

Thanks

Answer 1

You could use a table to store values. You can then refer to this table in queries, and/or use DLookup to retrieve values from the table.

---

Regards, Hans Vogelaar (http://www.eileenslounge.com)

Answer 2

Hi. There must be more context to what you read because it all depends on what your database is supposed to accomplish. If you bind a form to a table with many fields, you could still end up with a form with a lot of controls. If you're trying to clean the look of the form, you can use tab control pages or subforms depending on your table structure. Can you tell us more about your database? Thanks.