Control matrices VBA Access 2003

[kunguito]

Hi,

How can I do it to place a matrix of controls on a form? That is, that I can access them through a single routine with the Index as a parameter.

My difficulty is to name the controls.

Is it possible that access 2003 like Visual Basic 2005 doesn't allow anymore control matrices?

Thanks!

KUNG

[OBP]

Can you clarify what you mean by Matrix of Controls?
Do you mean Access Form Controls?
Form Fields?

[kunguito]

I think I mean access form controls (combobox, optionbutton, etc).

What I'm trying to do is to place a set of rows of comboboxes, 5 columns each, where the rows represent tasks and the columns days of the week (from monday to Friday). So the user can add or delete activities (rows) and then say, by using the combobox, how many hours he worked on that project that day.

This leads to my following question: should I place all the controls on the form and then show/hide them? or should I Load/unload them during runtime?

Thanks!

[OBP]

You will need to consider the date of the days of the week or have week numbers.
You will also need fields in a table to store the Combo Box selections.
The Combos can easily be added to the Form manually using the Combo Wizard.
What is the Structure of your Tables?