I have a listbox that fills. It shows the field Keyword.
I use the rowsource to drive a report.
Me.LP1.RowSource = "SELECT TXMASTERS.Barcode, TXCLIPS.NNAME AS Name, TXCLIPS.Comments, " _
& "TXCLIPS.Start AS TimecodeIn, TXCLIPS.Duration, TXMASTERS.SportorSports AS Sport, " _
& "TXCLIPS.StarRating, TXCLIPS.Shot, KEYWORDS.Keyword, TXMASTERS.SeriesName AS Programme, " _
& "TXMASTERS.EpisodeTitle AS Episode, TXMASTERS.Competition" _
& " FROM (TXMASTERS INNER JOIN TXCLIPS ON TXMASTERS.ID1=TXCLIPS.ID1)" _
& " INNER JOIN KEYWORDS ON TXCLIPS.Comments Like '*' & KEYWORDS.Keyword & ' *' " _
& "WHERE TXCLIPS.NName Like '*" & Replace(Me.LNAME11.Caption, "'", "''") & "*' " _
& "ORDER BY 1, TXMASTERS.BARCODE, TXCLIPS.Start"
On the report I have a textbox, with its source set as Keyword. However the box does not get filled. Anyone know why, thanks
I use the rowsource to drive a report.
Me.LP1.RowSource = "SELECT TXMASTERS.Barcode, TXCLIPS.NNAME AS Name, TXCLIPS.Comments, " _
& "TXCLIPS.Start AS TimecodeIn, TXCLIPS.Duration, TXMASTERS.SportorSports AS Sport, " _
& "TXCLIPS.StarRating, TXCLIPS.Shot, KEYWORDS.Keyword, TXMASTERS.SeriesName AS Programme, " _
& "TXMASTERS.EpisodeTitle AS Episode, TXMASTERS.Competition" _
& " FROM (TXMASTERS INNER JOIN TXCLIPS ON TXMASTERS.ID1=TXCLIPS.ID1)" _
& " INNER JOIN KEYWORDS ON TXCLIPS.Comments Like '*' & KEYWORDS.Keyword & ' *' " _
& "WHERE TXCLIPS.NName Like '*" & Replace(Me.LNAME11.Caption, "'", "''") & "*' " _
& "ORDER BY 1, TXMASTERS.BARCODE, TXCLIPS.Start"
On the report I have a textbox, with its source set as Keyword. However the box does not get filled. Anyone know why, thanks