How can I go to the next record?

[TheStriker]

Hello,

I am trying to create a survey application that would store values in a record on a table. I have one form for each question with fields from the table. However I can't figure out how to start a new or go to the next record when I reach the last question (form). Can anybody tell me how to accomplish this. Also, is there a way for it to skip records that have a specific value like Yes or No?

You help is badly needed and most appreciated.

Thanks in advance.

 

[FancyPrairie]

When you place a command button on your form the Wizard will ask you what you want the command button to do. One of the options is to goto the next record. If you select that one, it will generate the code to do it. Check out the code it generates.

 

[TheStriker]

I've tried to use a command button wizard but and it didn't accomplish what I needed. Each form displays data from the first record, even if the previous records displays another record, when I click a command button that takes me to the next form, it displays data from the first record. I need a way to link all forms with the same record and then when I reach the last form, take me back to the first form with the next record.