I keep getting this run-time error and im not sure why. Its saying Syntax error (missing operator) in query expression 'Store Name = 'test store".
I have a list box thats connected to a Query and im trying to make it so when I double click on the store in the listbox it opens up a form to edit the details.
I have a list box thats connected to a Query and im trying to make it so when I double click on the store in the listbox it opens up a form to edit the details.
Code:
DoCmd.OpenForm "Tbl_StoreMasterEDIT", , , "Store Name = '" & Me.SearchResults.Column(0) & "'"