Page 1 of 1

add row number to a Subform

PostPosted: Tue Jul 18, 2017 7:45 pm
by willemgouws
Hi. I would like to ask the user some questions 1 to 10 in a subform.

Row: Question: . Answer:
1. | (Display SQL= {Select Question From Questions WHERE Question_nr = 1} ) [________________]



how do I use a row number in my SQL display object?

like:
Select Question From Questions WHERE Question_nr = #subformROWnumber#


subfrom.png
subfrom.png (14.48 KiB) Viewed 524 times

Question sql.png
Question sql.png (26.64 KiB) Viewed 524 times