Hi please can someone help,
I am having a problems displaying data from an access db to a datalist. I have a dropdown field that has a list of areas and when an area is selected it looks up all the data for that area and displays it in the datalist.
I realise that its my sql code, but being new to this have no idea what I have done wrong. This is my varible is stParish.
Dim stSelect As String
Dim stFrom As String
Dim stWhere As String
Dim stParish As String
stParish = drpParish.SelectedValue
stSelect = "SELECT Format(tbl_events.startDate, 'dd MMM yyyy') As DateStart, Format(tbl_events.endDate, 'dd mmmm yyyy') As DateEnd, tbl_events.eventTitle, tbl_events.eventDesc, tbl_events.Venue, tbl_events.Parish, tbl_events.contactName, tbl_events.contactNumber, tbl_events.contactEmail, tbl_events.webAddress "
stFrom = "FROM tbl_events "
stWhere = "WHERE tbl_events.Parish = " & stParish
Thank you