Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2005
    Posts
    31

    Question Unanswered: On exiting form(2), refresh listbox found in form(1). Can you Help?

    Hello. I was trying to work on a sub that on exiting form(2), could refresh control found in form(1). The code could also be triggered from [exit] button.

    I've tried:

    forms!SupervisorView!AgentListbox.Requery but... it doesn't seem to work.

    However... if I place the same exit button in form(1) and chage the code to:

    Me!SupervisorView!AgentListbox.Requery it, works just fine but it's an extra click that could be eliminated.

    Any ideas? Thx!

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    When you exit Form 2, is form 1 opend on the screen? If not you have to open it first then run your code....

  3. #3
    Join Date
    Oct 2003
    Location
    London
    Posts
    341
    When you close form 2 why don't you add a line in your code to set focus to the supervisorview form.

    The below is just a guess what it would look like though

    forms!SupervisorView!AgentListbox.SetFocus
    forms!SupervisorView!AgentListbox.Requery

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •