By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,294 Members | 2,484 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,294 IT Pros & Developers. It's quick & easy.

Is it Refresh problem?

P: 97
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!
Apr 28 '08 #1
Share this Question
Share on Google+
1 Reply


P: 97
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!
May 1 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.