Another Data Access Page Question

[Question Boy]

1. Is there a way to build an SQL statement to drive a dropdown list in a
data access page? I would like to apply a sort order and a criteria for the
displayed records.

2. Instead of using a table or query as a dropdown list's ListRowSource, can
I use a value list? How?

Thank you,

QB

 

[a a r o n . k e m p f]

I usually use HTML in the middle of an ASP page.. so yah.. of course
you can do all of those things.

Do you know anything about the document object model?

I use vbscript in my webbrowser-- because it 'just works' and I hate
having people download 19 different versions of java garbage.

I've got some code examples to give you when I find them.. but that
should put you in the correct direction.

PS - I _NEVER_ edit the HTML / DAP by hand.. only within MS Access.

 

[Question Boy]

I would truly appreciate it if you could give me an example!

Thank you,

QB