This code works fine unless the stadium name contains an apostophe. I have so far been less than successful in adding a "wild card (*)".
Any help would be appreciated.Code:DoCmd.OpenForm "ProStadiumListF", acNormal, , "[Stadium]=" & "'" & [Stadium] & "'"
Thanks
Jim O