gakiss2
Registered User.
- Local time
- Yesterday, 18:00
- Joined
- Nov 21, 2018
- Messages
- 168
I want to use a Tabular for to go down a list of 'records' which the user may take action or not. There is a cbo field Decision on the form. The user makes a choice which is recorded. There are two of the five choices which means the 'record' should be removed from the form view. Those choices are 'Close' and 'Ignore'. There are other choices which are just recorded and they stay in the view. The method I use to make Close and Ignore disappear is to tie that to Query the Form is based on. In order to make them actually disappear I have coded a 'Requery' to occur based on the 'On Change' event. After some sweat and tears I even figured out how to have cursor to go back to the form the user was working on. It was RecordsetClone.FindFirst and Bookmark. I do not 100% understand what is going on since I got it from a google search but it works. Long introduction to the problem... If the user chooses 'Ignore' or 'Close' the form Requeries and the entry disappears as desired but the cursor (view) rolls to the top of the form. Not an earthshattering outcome but it could be annoying to have to scroll back to where you were each time you use those choices. An Ideal solution would have the cursor go to the next record (by mrr-num) which should also be the 'Next' record anyway since the query sorts on mrr-num. also, the mrr_num was originally a text value but I changed it to number in my attempts to solve this. I much appreciate any help. code in next post.