Hi Garry, this form is intended to be a form prepared for each
client/member which is populated with info from the spreadsheet and
then
can be extended further with additional information.

Hope this clarifies it

Not really! I have to assume the 'form' is a predesigned worksheet OR a
predesigned userform. (symantecs!)

Assuming a predesigned worksheet, I need to know the structure/layout
of the target 'form' for each client. The approach would be to step
through each record and put the contents into the respective client
'form' where the data should be positioned.

It might be better to post a link to where your file can be downloaded
so people who can help can see the scenario for what you're trying to
accomplish.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion