What exactly are you trying to do?? If you want to edit the ODBC query everytime then you could probably do this using VBA. Create a text entry on screen which shows the basic structure of the query then, in the spaces you want the user you be able to enter their own text, put a textbox (a drop down box would be better to limit the number of entries and remove the possibility for finger trouble!).
Something like ..." select * from " textbox1 "where tag = " textbox2 etc,etc

Put a command button on the processbook display and then put some VBA code behind it that creates the query string and uses it. eg.
Dim strquery as String
strquery = "select * from " & textbox.1value & "where tag = " textbox2.value
obdc.query = strquery

or something similar (I can't remember the full syntax required but it's not too far from that I think)

Hope this is what you were looking for!