G
Guest
Hi all,
I have a search tool used to look up a last name, it then opens a view
screen (View_Customer) based off of the search criteria from the previous
form. On the view screen, I have a button to add notes, that then display on
the view screen due to a requery of the view screen when the note form is
closed. A problem I am having is the requery brings you back to the first
record in the result set of what was originally brought up. For example, if
I look up the last name "Smith", it may bring up multiple records - upon
scrolling through these records and then finding the one I want to edit, I
would like to be able to enter the note and have the focus remain on the one
I just edited. Is there a way that when I open the note screen, it will then
filter directly to that one order (similar to the right click, filter for
option) removing all others from the view? What other options are there?
Help always appreciated! Thanks!
-gary
I have a search tool used to look up a last name, it then opens a view
screen (View_Customer) based off of the search criteria from the previous
form. On the view screen, I have a button to add notes, that then display on
the view screen due to a requery of the view screen when the note form is
closed. A problem I am having is the requery brings you back to the first
record in the result set of what was originally brought up. For example, if
I look up the last name "Smith", it may bring up multiple records - upon
scrolling through these records and then finding the one I want to edit, I
would like to be able to enter the note and have the focus remain on the one
I just edited. Is there a way that when I open the note screen, it will then
filter directly to that one order (similar to the right click, filter for
option) removing all others from the view? What other options are there?
Help always appreciated! Thanks!
-gary