Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Go to record found by Criteria in Data Form

Using the Criteria option in Data Form along with the Find Prev and Find Next buttons, you can find and display information on a particular record. However, it doesnt actually take you to that record in the database.

For example: Lets say that my cell pointer just happens to be in cell A2 of the 1st record when I open the Data Form. Using certain fields in the Criteria screen, the form displays information for me about the 75th record. However, when I click Close on the Data Form, the cell pointer is still in A2 of the 1st record rather than A76 of the 75th record.

Is there any code that will actually take me to whatever record I find using Criteria in the Data Form?

Many thanks,
Paul

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Write record from Form to new row in spreadsheet Tony Excel Discussion (Misc queries) 0 March 18th 10 07:35 PM
record update VBA form Roy Gudgeon[_2_] Excel Discussion (Misc queries) 0 March 15th 10 04:27 PM
Control on a form to find a record Terry Excel Discussion (Misc queries) 2 September 7th 08 03:04 PM
Current row/record shown when opening data/form buczacz Excel Programming 8 October 22nd 03 04:31 AM
Record changes made from a vb form Dave[_18_] Excel Programming 1 August 6th 03 02:51 AM


All times are GMT +1. The time now is 02:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"