Syntax Error

ddrew

seasoned user
Local time
Today, 08:03
Joined
Jan 26, 2003
Messages
911
Hi Im having a problem with a Syntax Error. I have created a search page which is fine, when I double click on an item in the search results it should then open up a different form at that record. Trouble is I get a Syntax Error instead. Ive used this code before and I cant figure out what is wrong, could someone take a peak please?

Be aware I many of the buttons will not work due to downsizing for zipping and posting!
 

Attachments

Hi, ddrew!

I think it is quite simple. In your search criteria you use "ID=" & variable. ID is Number type, your variable is String type. It wont work this way.

Krava
 
OK, what can I do to correct it please?
 
Hi, ddrew!

Well, I have modified your db slightly. I have changed the data source (query) of the list box in th esearch form. I have added ArtistID and it is the first field. Then, I have extended Number of columns for list box to 7, but I have set up the columnwidth of the first one (ArtistID) to 0, not to show it in the list box.
Then I basically kept all inyour code as it was and it seems to be working. Now the list box returns ArtistID that matches the data type of your Search criteria.

Krava
 

Attachments

Thanks very much for help. Now all I have to do is incorporta eit all in the main DB, once again thanks!
 

Users who are viewing this thread

Back
Top Bottom