Database Query Help Needed Please

[Matthew]

I have designed a database that allows you to manage all the words
for songs. So the user opens the database they can either add a song
to the list by entering the SongCode, SongName and they browse to
where they placed PDF file which has the song words

Then they can go and search for a song by entering in the SongCode
and then it opens up the query displaying the name of the song and
the hyperlink to open up the PDF File.

What I am after is their away that when the user types in the
SongCode and presses enter it automatically opens up the PDF
Document instead of showing that record a clicking the hyperlink.
And if they type in the wrong SongCode it comes up with an error
message saying "you have typed in the wrong code.

Matthew