Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2008
    Posts
    4

    Unanswered: How to do this I need help

    I have two forms both pulling from the same query and you can add a new record in lets say form A and form B has the all the same fields as A but with more rite . So if i add a new record in A i can only see that new record in B if i close B and open it, is there another way that i can see the new record i created in form A in B with out reopening form B? How to refresh/update form A atuomatically is that possible
    Last edited by jenine; 01-18-08 at 16:18.

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Forms!FormB.refresh
    or
    Forms!FormB.requery

    If that doesn't work, refresh Form A before you refresh form B (you can refresh the form which has the focus by issuing a Refresh command by itelf.) Perhaps do a Refresh command in Form A in the AfterUpdate event and then do the Forms!FormB.Refresh (or requery).
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Jan 2008
    Posts
    4

    Thanks

    Thanks it works

Posting Permissions

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