Infinite
More left to learn.
- Local time
- Today, 13:33
- Joined
- Mar 16, 2015
- Messages
- 402
Hello, I have a list box that has lots of results (shows) and I have a macro set to open them upon double click a macro runs and opens up another form that has the details about the show. In the attached image there is the macro. The problem I have, is I also have a search, (http://www.access-programmers.co.uk/forums/showthread.php?t=188663)
I have in my query multiple (Like "*" & [Forms]![frmEvents]![txtSearchS] & "*")
I have one for the show name, 1 for the show state, and one for the Zip code the show was at. Now the problem is, if I search for MO state fair, and I have 2 shows, if I open one of them, I get the details of that show, but if I search for a zip code and open them, nothing shows up, and if I search for the state MO, (and I have lots of shows there) ill get lots of shows, but if I have a show named TestMOshow and that comes up, and I try to open it, it opens up to a blank page. Not sure why this happens.
I need this fixed as I will know we did a show in Florida, and if I search for that show, I will find it, but if I try to open it, it doesnt open up correct. Thanks for the help!
I have in my query multiple (Like "*" & [Forms]![frmEvents]![txtSearchS] & "*")
I have one for the show name, 1 for the show state, and one for the Zip code the show was at. Now the problem is, if I search for MO state fair, and I have 2 shows, if I open one of them, I get the details of that show, but if I search for a zip code and open them, nothing shows up, and if I search for the state MO, (and I have lots of shows there) ill get lots of shows, but if I have a show named TestMOshow and that comes up, and I try to open it, it opens up to a blank page. Not sure why this happens.
I need this fixed as I will know we did a show in Florida, and if I search for that show, I will find it, but if I try to open it, it doesnt open up correct. Thanks for the help!
Attachments
Last edited:
