Hi

I have a form with two Text elements: Name & Title. This info will be sent to an Access database.

The user may need to enter more then one Name/Title, but can only add them one at a time. Rather then submitting each entry to the database individually, my thinking is to put them into an array, until the user has finished entering names...

I'm not sure how to get the form values into the array, and also because I don't know how many Name/Title entries the user could be entering, I'm not sure how to add new indexes to an array.

Any suggestions would be great.
Thanks

Terry

Why dont you place multiple form name and title fields on the form so when they hit submit they all get posted at the same time?
Obviously you can loop thru the posted form fields detecting if they hold a value, is so insert.
OR
Do they go from page to page to page...and fill in details on each page? this is why you need ot store values? I would use hidden form variables, when they get to the end of the line you have all values from previous pages.

Or if you need to create an array not knowing how many elements you need, look up ReDim - it's fairly strait forward

Wind is your friend
Matt