Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2001
    Posts
    175

    Question Unanswered: Forms - Why would this happen??

    On my main form I have a button that calls a linked form. I would enter data on the linked form and exit the form to return to the main form. If I go back into the linked form, I sometimes don't see the data I have entered (although it is in the table). However, if I exit the the main form and then open it and go to the linked form, the data is displayed.

    Any reason why this happens?????

  2. #2
    Join Date
    May 2002
    Location
    London
    Posts
    87
    A cannot see the exact situation but you may want to requery the form to show the refreshed data.

    I am guessing that when you reload the linked form it shows righ but if you have it already loaded and switch to it then it may be out of date. The code:

    me.requery from the linked form or Forms("frmLinked").Requery from the main form will do the trick. On the linked form maybe the OnActivate event would be a suitable place to doa requery.

  3. #3
    Join Date
    Sep 2001
    Posts
    175
    Thanks - I will give it a try

Posting Permissions

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