Please see the support ticket update!
The issue I have found is that the prompt for the record set has something to do with having to be connected to the actual server (designating it as a test server), even though I am not using a database, once I did that, everything came into play and worked fine.
I'm having a hard time understanding why that is such an issue if a database is not involved in the form processing. Does this maybe have to do with the bindings being created?
Thanks agan for your help!