Go to search

[CHEECO]

Good day all. I have a really strange situation happening here. I am trying to insert a go to search or go to combo box in some forms. They are all working except for one.

I put the below code number (1) in






(1) SELECT [ID], [Movie Title] FROM MovieCollection WHERE [ID]<>Nz(Form![ID],0) ORDER BY [Movie Title];

And when I save the form it changes it to code number (2) and it will not work. It keeps sticking the word "AS" between the words "Movie AS Collection" The name of the table is "Movie Collection" not "Movie AS Collection". Its pissing me off.


(2) SELECT [ID], [Movie Title] FROM Movie ASCollection WHERE [ID]<>Nz(Form![ID],0) ORDER BY [Movie Title];

[ssanfu]

You shouldn't have spaces in object names.

Try

SELECT [ID], [Movie Title] FROM [Movie Collection] WHERE [ID]<>Nz(Form![ID],0) ORDER BY [Movie Title];

Note the brackets around "Movie Collection". If you have spaces in a name, you must enclose the name with brackets..