Results 1 to 3 of 3
  1. #1
    Robbyp2001 is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Oct 2011
    Posts
    25

    Getting a continuous form to stay where it s.

    Hello folks, I hope someone here can help. I have a continuous form of records that include a date in and a date out. When I select a particular record from this list, a pop up form with a combo box appears. From this combo I select a record which then populates the date-in and date-out on the original record from the continuous form. This works perfectly, however, in order to populate the date-in box, I use a query that updates it from [date-in].date() to date-in + 7. It then refreshes the continuous form so that I can see both dates appear in real time. This is working well, until I have to scroll down through the records. When I update the date-in and refresh, the continuous form goes back to the first record, meaning that the record I originally selected disappears from view. My question is, how do I populate both date boxes in real time and get the record (continuous form) to remain where I can see it? It's not a major problem, just annoying. I can scroll down to find the record and confirm that the process was successful. I'd rather it just stayed in view.



    Thanks folks

    Rob

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Maybe this link will help: http://www.baldyweb.com/Requery.htm

  3. #3
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2013 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Code:
        Dim CurRec As Long
        CurRec = Me.CurrentRecord
        ...your code here ...
        DoCmd.GoToRecord , , acGoTo, CurRec

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

Similar Threads

  1. Replies: 11
    Last Post: 04-09-2016, 08:54 PM
  2. Creating new object of form stay hidden first
    By Ruegen in forum Programming
    Replies: 11
    Last Post: 09-07-2014, 09:00 PM
  3. Refilter form and stay on same record
    By ny1994rangers in forum Forms
    Replies: 1
    Last Post: 04-17-2012, 12:04 PM
  4. form won't stay in restored down size
    By markjkubicki in forum Forms
    Replies: 4
    Last Post: 08-15-2011, 07:46 AM
  5. Replies: 3
    Last Post: 09-16-2010, 09:50 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