Can anyone advise me if it is possible to pass a parameter value, defined by the user of my VB app to a SQL database view and return the appropriate recorset? e.g.User enters
a date, and the view filters my databse records and returns only those that match the date entered to the data grid. How would I go about writing a VBA code to dictate the value of the parameter in the SQL view?

Any help would be greatly appreciated.


Ray