Locking a Record

G

Gary Dolliver

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
 
R

ruralguy via AccessMonster.com

Try Me.Refresh instead of Me.Requery.

Gary said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top