Tech Support Guy banner
Status
Not open for further replies.
1 - 5 of 5 Posts

·
Registered
Joined
·
211 Posts
Discussion Starter · #1 ·
Hello Guys,

I have a form called "FrmClientSupportOverview" Which is the a list of all support calls. I have a button at the top of the list to add a new record i.e...new support call. The Form it opens is "FrmClientSupportNew" this form sits on top "FrmClientSupportOverview", and when i have filled in the new entry, i want it to close "FrmClientSupportNew" and update "FrmClientSupportOverview" with out manually refreshing, or closing and opening the the form "CleintSupportOverview"

There must be a simple code to do this? and if so...where would i put it? Pretty please :eek:

Thanks
 

·
Registered
Joined
·
19,896 Posts
Presumably you have a close form button on the "FrmClientSupportNew" form.
Try Adding the following code to the button before the close form action
RunCommand acCmdSaveRecord
forms![FrmClientSupportOverview].requery

But why not just add a new record on the "FrmClientSupportOverview" form?
 

·
Registered
Joined
·
211 Posts
Discussion Starter · #3 ·
Superb!! Thankyou very much OBP...that has worked a treat, i've been searching high and low through google for ages!!

The form "FrmCleintSupportOverview" is locked, so its only able to sort instead of amend the data. Its done on purpose to stop accidentally changing the data. Plus, it does not display all the data you want to see on the overview, so i have a button next to it to show individual records, with all the data.

Hope it makes sense?

Im going to put that code into my module for safe keeping, so i can refer back to it in the future. :)
 

·
Registered
Joined
·
19,896 Posts
Yes it makes sense.
I put all my individual code in to a Word Doc with a simple heading, which you can then search for key words. I have posted a copy of it on here in the past.
 

·
Registered
Joined
·
211 Posts
Discussion Starter · #5 ·
I have your VBA copy. You sent it to me a while back :), i have looked at since...but its alot to break down and understand for a begginner like me... i just completed a course in VBA for begginners (the only course i have done in Access), it was very difficult to follow. It helped me understand a few things, but its knowing where to start...practice makes perfect i guess. I could have done with the 2 day course being broken down into a ten day course haha!!

Thanks again :)
 
1 - 5 of 5 Posts
Status
Not open for further replies.
Top