I have a database on access connected to my program. I have a command button "find" that when clicked, you get an input box that asks you to input the title of the CD. However, the Find command doesn't work even after its programmed...CAn anyone help me in trying to program it??
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Programming a find command--HELP!!!!!
- Thread starter Forgie
- Start date
Try to create a command button and a textbox<br> Create a DAO and link it to the database. If u want to search for a record from a table (e.g Product) by using a field (e.g Product ID) type the code below in the click event of the command button.<br><br> Data1.recordsource= "SELECT * FROM Product WHERE [Product ID] = +"Textbox"<br> Data1.refresh<br><br>I hope this helps.
- Status
