I hope general design questions are appropriate for the forum ... if not
please let me know.

i work with kids for a non-profit and I'm creating a Client Info form
on a worksheet. I plan to store all client info in a list on a separate
worksheet and use VBA to populate the form with a particular client's
current info - work on the form updating/changing/viewing client info
- use VBA to update the client info list with any changed data. There
is a fair amount of info for each client/record - maybe 75-100 fields,
however there would only be 25-35 client/records .
So I'd have:
Wks 1: A Main Menu with list of clients displaying some key data -
Macros to get me to individual clt form, and add or delete clients
Wks 2: Hidden database storing all Clt info.
Wks 3: Client info form

I wanted to keep all the client data in a separate wks list rather than
1 wks form per client so i could more easily make changes to the form
design.

I'm a beginner at VBA - but I feel pretty confident about working out
the programming - my question: Is the way I've gone about structuring
the thing "good design".

Thanks in advance for any feedback.
Richard


--
rgarber50
------------------------------------------------------------------------
rgarber50's Profile: http://www.excelforum.com/member.php...o&userid=11350
View this thread: http://www.excelforum.com/showthread...hreadid=393518