parameterised view sql express 2005

[ken]

Hi,
I connected Access 2003 to SQL express 2005. My question is in access
if I have a query, I can put in the criteria a function to return some
kind of criteria statement. I can also redefine the query in some event
procedure in a form using VBA.

Now that I'm using SQL, I want to do something similar with views. I
have a list box that I want filtered on a form. The values for the list
box come from a view. I want to filter this list box, so I was told to
create a parameterized view. How then would I pass the parameter to the
view?

Right now I'm trying to see if I could redefine the view using VBA,
like we do with Query Defs.
Qry.SQL = "New SQL"
I wonder if I can do that with views...