Determine Row Number using FormCalc

Avatar

Avatar

robnagby

Avatar

robnagby

robnagby

15-12-2008

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?

Replies

Avatar

Avatar

pguerett

Avatar

pguerett

pguerett

15-12-2008

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

Avatar

Avatar

robnagby

Avatar

robnagby

robnagby

15-12-2008

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?

Avatar

Avatar

pguerett

Avatar

pguerett

pguerett

16-12-2008

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

Avatar

Avatar

robnagby

Avatar

robnagby

robnagby

16-12-2008

n_linus at yahoo dot com



Thanks!

Avatar

Avatar

pguerett

Avatar

pguerett

pguerett

16-12-2008

Just sent it