Is it Refresh problem?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • loisk
    New Member
    • Sep 2007
    • 97

    Is it Refresh problem?

    Hi,

    I added more records recently to my MySQL table which shows all the added records. However, one of my access forms (data entry screen) does not show newly added records while other form (filter form) displays those records. I don't understand why this happens.

    I did Refresh and also updated the linked tables through linked table manager menu. Any comment will be appreciated!
  • loisk
    New Member
    • Sep 2007
    • 97

    #2
    Originally posted by loisk
    Hi,

    I added more records recently to my MySQL table which shows all the added records. However, one of my access forms (data entry screen) does not show newly added records while other form (filter form) displays those records. I don't understand why this happens.

    I did Refresh and also updated the linked tables through linked table manager menu. Any comment will be appreciated!
    Here's what I found out in case it can help someone else...

    My form is linked to two MySQL tables via a query.
    I loaded some records only into one of the tables and forgot to do the same thing to the other table which contains DOB info. When loading records is done partially, but not to both table, then Access ignores the data loaded partially.

    My problem is solved now after I did load the data to the other table. Thanks for reading it!

    Comment

    Working...