This approach does not seem to work and based on how the records are stored in the database I wouldn't expect it to work. It doesn't seem possible to add multiple criteria to the where clause in this case but please clarify if I missed something.
I found this old entry that describes searching through records for specific criteria: crosstec.org/en/forums/3-breezingforms-f...records.html?start=0
I want to be clear because what is described in the thread linked above seems overly complicated for what I'm trying to accomplish.
To summarize, I have users entering information in the multiple-page form. Each time a page is completed, there is an element in that page that gets set to "Complete". When the user logs in next time and the form loads, I want the form to check the last page that was set to "Complete" and navigate to that page.
So far, attempting to get the value of the "Complete" element in the form init script failed because the value is empty during the init process and only populates after the script is complete. In the past I could access the value of the "Complete" element during the init script and this is how I was doing it (I don't know why it no longer works). Is there an easy way to do this that I'm missing?