I currently have a database in access with one table in and 5 different fields. I have made a vb form which displays the data in this database in individual textboxes and allows you to look through the records. I have made one combobox with a list of the column names. Once one of these are selected it shows the user a list of the values in the column which the user then selects one. I then have a search button which i want to load the records which have that value in that specific field. What code do I need on that search button to fill the textboxes with the nessessery data, and how do you do a reset button that reverts back to the normal data minus any search restrictions?
Thanks in advanced