Determine Row Number using FormCalc

[robnagby]

I'm setting up a table with many questions. The questions asked will change depending on the answers given. Each row will contain a question. The first column is the question number. I'd like the question number to change based on it's position in the table. I hide the rows for questions that are not being used. If the question is in the 5th row, it should be question 5. Is there a way to determine the row number and then have it change if it moves up or down in the table?

[Former Community Member]

You can get a subform instance number by using the parent.index on any object in the subform.

[robnagby]

The problem with that solution is that if I hide a row because the question is not relevant, the numbers don't adjust. For example:



1 What color is your hair?

2 How old are you?

3 How many fingers do you have?



I hide question 2 because it's no longer relevant and here's what shows up:



1 What color is your hair?

3 How many fingers do you have?



I need it to appear like this:



1 What color is your hair?

2 How many fingers do you have?

[Former Community Member]

I think I have a sample of something similar. Post your email and I will send it.

[robnagby]

n_linus at yahoo dot com



Thanks!

[Former Community Member]

Just sent it