I created a form that has lookup fields for questions, and those field become visible depending on a dropdown list choice. The issue I have that the questions exist in a specific order in the list, and it seems that the form evaluates the lookup fields in a different order, causing the questions to appear out of order. This is especially troublesome since some questions remain hidden and appear on the condition of an answer to the question above.
So - how do I make sure that the computer evaluates the lookup fields in the order that they appear on my form (top to bottom)?
Create a view on your list with your desired order, then set that view on the "Source View" property of the control