Results 1 to 5 of 5

Thread: Tab Object

  1. #1
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Unanswered: Tab Object

    I have a list box on a tab object on the form, when the user double click the list box it opens a new form for the selected recored, where the user can edit and change it. Now after closing the secound form, I'd like to refrish the Listbox on the Tab with the changed new data . I tried
    Forms("MainForm").Repaint
    Forms("MainForm").Requery

    Also
    Forms("MainForm")!ListBoxName.Requery
    Forms("MainForm").thisTabName.ListBoxName.Requery

    but all in vain
    Hope I find the answer by you....

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Where in code were you placing these commands?
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Thanks for your reply,
    I put it in the secound form

  4. #4
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Forms!MainForm!Listboxname.requery - does that work? Is the form available to be requeried on?
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  5. #5
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Thank you for your reply,
    yes the first form is still opend while the secound pops up....

Posting Permissions

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