Results 1 to 3 of 3
  1. #1
    EddieN1 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    313

    Starting a Datasheet View at Selected Record

    I have a simple form in datasheet view in Company Name sequence. By default it starts the list at the beginning. I would like to put a combo box in the form header that pulls down the companies to allow the user to select the starting company to list. I don't want to go directly to the selected company, I just want the list to populate starting with the selected company. I can create the combo box and I know I use the After Update event to get the selected value, but how do I restart the list. Ideally, I would still like the operator to be able to scroll up and down after the list is redisplayed starting with the selected company. Thanks, Eddie

  2. #2
    ssanfu is offline Master of Nothing
    Windows 2K Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Maybe this will help you.

    http://access.mvps.org/access/forms/frm0005.htm

    Is this what you are trying to do???

  3. #3
    EddieN1 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    313
    That did it. Thanks.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Datasheet view in tab only
    By cdzajp in forum Forms
    Replies: 1
    Last Post: 06-22-2011, 12:44 PM
  2. SearchBox and Datasheet View
    By gio25 in forum Forms
    Replies: 3
    Last Post: 03-23-2011, 06:07 PM
  3. get data from selected datasheet row
    By Grooz13 in forum Programming
    Replies: 0
    Last Post: 03-17-2011, 01:01 PM
  4. Replies: 1
    Last Post: 07-14-2010, 01:34 PM
  5. Datasheet View
    By Evgeny in forum Programming
    Replies: 6
    Last Post: 04-28-2010, 10:17 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums