Access 2010: Survey Application

[rpNewBee]

I'm relatively new to programming in Access and I would like some ideas on how to do a Survey application. Here is the basic idea:



Lauch Start_Form
While not end of Survery
Get Next Question from DB
Call a display form to display question and get response
Close the form
End Loop

I have started programming this but I've encountered a problem. Once I enter any loop, whether in the form code or a module function, the code just keeps going through the loop. It never stops to display the form and accept the response to the displayed question.

Any ideas?

[rpeare]

What is your table structure like right now and can you give an example of how your data appears within those tables.

[orange]

google duane hookum At your survey

He has an app that many use.

[RuralGuy]

Here's the Duane Hookom link: http://www.rogersaccesslibrary.com/f...97d69623726852

[rpNewBee]

Thanks for the information. I will check this out.