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

form refresh

P: 2
I have modal pop-up form1 showing list of items. There is a button that opens a new modal pop-up form2 which is a tabbed form (not subform) to add items to form1, form1 is still open behind form2. This all works fine, but when you click save button on form2 it saves new data to database and closes taking you back to form1
but does not refresh new data to form1 unless you (shift F9) or close form1 and reopen or use refresh button on form1.
I would like to have form1 refresh data as soon as form2 is closed from the save button. I can do a timer event on form1, but this flashes the screen...which is annoying. I have tried various methods to make this work but just can't seem to get it to work. If form2 was a subform of form1 then refreshing mainform would not be an issue. Can anyone shed some light on this?
Aug 23 '06 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Add this code after the save code on the click event of the Save button on Form2.

Forms("Form1").Refresh


I have modal pop-up form1 showing list of items. There is a button that opens a new modal pop-up form2 which is a tabbed form (not subform) to add items to form1, form1 is still open behind form2. This all works fine, but when you click save button on form2 it saves new data to database and closes taking you back to form1
but does not refresh new data to form1 unless you (shift F9) or close form1 and reopen or use refresh button on form1.
I would like to have form1 refresh data as soon as form2 is closed from the save button. I can do a timer event on form1, but this flashes the screen...which is annoying. I have tried various methods to make this work but just can't seem to get it to work. If form2 was a subform of form1 then refreshing mainform would not be an issue. Can anyone shed some light on this?
Aug 23 '06 #2

P: 4
Hi, can i just say that this post just helped me massively.

Thanks alot guys, this site is basically getting my A for IT lol
Feb 9 '08 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Hi, can i just say that this post just helped me massively.

Thanks alot guys, this site is basically getting my A for IT lol
Glad to be able to help :)
Feb 10 '08 #4

Post your reply

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