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!!
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!!