Hi all,
I am new to the forum and new to access as well. I do have Excel developer experience so coding is not new to me. I hope to use this forum to get experienced with access as well.
Here is the thing i am trying to pull off.
I have a form that searches for keywords in another form (form data). The result of a command button on this search form is a query that shows the matches that the search has found. The query consists of two columns: one colum with an identifier and a column that counts the hits of my search (eg when my search consists of 3 words and two of these 3 words are found this column would show 2). The count column is sorted in decend so that the "best" hits are shown at the top.
Now i want 1) to open the form with the "best" hits and 2) have a command button on the form (form data) that will allow me to jump to the second best hit and then to the third etc.
How can i pull this off?
Thanks for any help!
Robbert