Coding help on Search function!

[nik707]

Dear Sir/Madam,

I am currently creating a database as part of an assignment. However, I have to do a search function (well its a big one but for now) where i get to choose a column from the list and then type the keyword, then it would return the search result to the my original input form.

I based it on this: http://www.techonthenet.com/access/forms/search2.php

However I am getting a syntax error. Since I learned VB quite a bit ago, I couldn't catch it though...could someone please help me out on this? Thank you!

These are the pictures explaining the error and the coding behind my 2 forms.

The error message: http://img258.imageshack.us/img258/5206/1stay8.png

The coding behind the search form: http://img143.imageshack.us/img143/5020/2ndvq1.png

The coding behind the input form: http://img258.imageshack.us/img258/9559/4thrp7.png

The table where everything is stored: http://img443.imageshack.us/img443/8071/3rdbv6.png

The combo list box has the original names of the 'Table' (is the name where everything is stored) table

Here is the database (if u want it)
http://rapidshare.com/files/118953845/CSR_Database.mdb.html

Again, thank you for your time and efforts!!

 

[dreamdelerium]

i believe the word "Table" is reserved. you can name your table Table and reffer to it in your code. call it something more meaningful

 

[nik707]

i believe the word "Table" is reserved. you can name your table Table and reffer to it in your code. call it something more meaningful

Thank you very much!! That solved it!