vary the number of controls/fields

[Guest_imported]

Good day,

I am running MS Access 2003 (VBA) on MS Windows XP and need some help.

I have a form (FrmMain) with a section asking who a document was sent to. I am using a message box to ask the user how many people the document was sent to and then trying to have that number of control sets placed on the form (with associated fields in a table - if possible). I say control sets because i need the person's [name], [organization], [dateSent], and [carrier] (FEDEX, e-mail, etc.). I asked for associated fields in a table because i think that is the only way to save data - is that right? I have not been able to do this at all. It seems like VBA should be able to do this, but how?

Efforts to manipulate tables was fruitless.

I'm still new at this VBA stuff so detail is helpful.

Thank you for your help and time.
55

 

[Andrzejek]

You could load controls 'on the fly', but can you use some kind of a Grid to display all of these information on your frmMain?

Have fun.

---- Andy