Using the value of a textbox in the select query string   

Hi,

  Since I am using MS Access 2007, I cannot use the AccessDataSource control 
(It won't recognize 2007 databases—Odd!), so I have to write the data 
connection.  I can't find any help with writing  the  select command (I think 
it should be like this:  "SELECT [ScheduledDay], [Date], [Campus], [Room], 
[Seats] FROM [Schedule1] WHERE ([SessionID] = ?)"  However, I am not sure how 
to bind the query to a textbox.  Can anyone explain to me the coding for 
Visual Basic?  I am assuming that I have to set up some parameter command, 
but I can't find any examples that I can learn from.

Thanks,
Anthony

date: Sat, 31 May 2008 14:33:03 -0700   author:   Anthony