Hello,
i'm pretty much a beginner and I find myself having trouble reaching my objective. I've made a simple table for now listing my movies with Title, Year, Cover(attachment) for fields. I have one query whom's criteria is Title, so Query by Title. I've made a simplistic form with a textbox which will be used for the title criteria, a button to run the query, and an embedded image box =[Movies]![Cover].
The goal is to type in the title, search, and the form itself be updated with the cover image rather then opening a datasheet. At this point, I can type in a title, search, and the query runs returning the correct results in a datasheet, minus the cover of course, but the image on the form never updates. I've come to realize i'm going about this the wrong way atleast for what I want to achieve, so I'd like to ask for some help heading toward the right direction. It may be worth noting I am not concerned with attaching images as the database will be rather small. Also, I am no vba / sql guru, but I am comfortable with general syntax overall from my experiences with c++.
To recap, the goal is to search a title via textbox, the form the textbox is on will update showing the cover image. I'd also like to apologize if i've missed this exact topic out there, I did look, but had a hard time finding something this specific. Thank you for your time.
For reference...
Table -> Movies
Fields -> Title, Year, Cover (Attachment)
Forms -> searcht (Textbox, button, embedded image)
Query -> Title Criteria (using Like "*" & [Forms]![searcht]![Text0] & "*")