Access Projects and Full Text Searches

[wilwayco]

Hi all. *Almost a complete* noob at all this, so please bear with me.

I have a form set up with a TextBox called SearchBox and a Button called GoSearch.

I have a StoredProcedure called SP1 that looks like this:

ALTER PROCEDURE dbo.StoredProcedure4 @parameter1 varchar(100)
AS SELECT dbo.Media.FileLocation, dbo.Transcription.Text, dbo.Transcription.Action
FROM dbo.Media INNER JOIN
dbo.Transcription ON dbo.Media.ID = dbo.Transcription.MediaID
WHERE FREETEXT (Text, @parameter1)

Ideally, this SP should be run at the click of the GoSearch button (with the OnClick Event wired up).

Coming from the MDB side of Access development, I would've simply put [Forms]![MyForm].SearchBox where @parameter1 is located. Unfortunately, SQL doesn't like the brackets. So I need to find a way to do so. Any Ideas?

(whether or not we're Full-Text Search doesn't really matter here, actually; FTS allows me to use the FREETEXT keyword...)

 

[cmmrfrds]

What do you want to do with the text when you locate it? Return records to a bound Form? Return records to a recordset for further manipulation? Other?