Tab control indexing

[Cameron]

I have a tab control being used on a sub form that has 10 tabs. Within each
tab there is aproximately 10 questions that the user will need to fill out
for entry of a record. what I need to do is when the user clicks off their
responces the code underneath needs to send the currently active location of
which tab the user is entering data in and then also which question they hace
clicked on. what would be the most productive way to do this? i thought maybe
a select case statement, but would like to use something a bit more automated
rather then code out each question's responce.

 

[mscertified]

"needs to send the currently active location"

what does this mean? send where? and why?

normally this data would be saved in whatever table that is bound to the form.

-Dorian

 

[John W. Vinson]

I have a tab control being used on a sub form that has 10 tabs. Within each
tab there is aproximately 10 questions that the user will need to fill out
for entry of a record. what I need to do is when the user clicks off their
responces the code underneath needs to send the currently active location of
which tab the user is entering data in and then also which question they hace
clicked on. what would be the most productive way to do this? i thought maybe
a select case statement, but would like to use something a bit more automated
rather then code out each question's responce.

STOP!!!!

It sounds like you're starting your database design with the Form. That's
backwards!

Get your *table* design set up correctly first, and then build your forms to
fit the table - not vice versa. Tables store data; forms are just windows,
tools to let you manage the data in tables. You're NOT entering answers on a
form; you're entering answers *into a table* via a form.

For survey data, consider Duane Hookum's "At Your Survey":
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

or

Roger Carlson's Training Registration database:
http://www.rogersaccesslibrary.com/download3.asp?SampleName=TrainingRegistration.mdb