Please can someone provide the code for the following problem from a
video store database:
where:
tblVideo(VideoID, Title, Artist, etc)
what would be done in frmFindTitle to select the recordset that
matches some words in the title?
For example, the customer wants a song that has 'rain' in the title
but can't remember what the full title is.
So far as I have got:
txtSearchWord (text box to input search word)
Event: afterupdate calls vba code which will select records like the
search word.
PseudoCode:
select from tblVideo
Title
where
tblVideo title = wildcard txtSearchWord wildcard
Any help greatly appreciated.