Data Access Pages - recordsets and comboboxes

[johnnymagee]

I have a Data Access Page created from a Form. There are several combo-boxes on the form and when something is selected in Box A the record source query for Box B is edited accordingly. I cant see any way to get this to work for the DAP (ie there is no listRowSource property for the combobox in the Editor, and I dont know how to edit queries in this environment)

 

[tsuji]

Should it not be more appropriate to post the question to access vba forum ?

http://www.tek-tips.com/threadminder.cfm?pid=705

 

[johnnymagee]

Well, maybe but I tried that yesterday and didnt get anywhere and since the code for a Data Access Page is written in VBScript it didnt seem inappropriate to try here as well.

 

[tsuji]

In that case, it might help if you can post relevant part of the code.

 

[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)

 

[tsuji]

That seems a better down-to-earth description rather than deep and abstract as the original. Maybe you can post the same to the forum 705 (access vba) or that you'd posted to (access form). They are very active forums. If you did't get a reply sofar, it is because you might have abused the bounty of the helping members there by the original wordings.