Converting Form to Data Access Page

[johnnymagee]

First I delete the query which is the listrowsource of the combobox

msodsc.RecordsetDefs.Delete "querysource"

then I build up a new SQL query - that works fine

then I want to add this new query as the listrowsource of the combobox but I dont know where to start this really as the DAP combobox doesnt seem to allow it in VBScript, whereas the VBA for a Form does.

I think this might be a starting point but I get an error "Invalid procedure call or argument"
set qdf = msodsc.Execute(ssearchsql)

 

[johnnymagee]

Sorry I cut and paste this. Not very clear is it?

I have converted a Form to a Data Access Page. There are several comboboxes on the form each sourced from a different query. As the user selects something in a combobox, the queries for the other comboboxes need to be rewritten. This works fine on the Form but not on the DAP. I have very little idea how to do this!