Are all of the fields required?
I think you are probably going to have to manually update your recordset code to make it truly dynamic and update the SQL statement and passed parameters based on what form fields have been filled out.
This is something we could help with in a premier support ticket.