SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


refreshing subform after right click and filter field in main form


refreshing subform after right click and filter field in main form

Author
Message
bdog2607
bdog2607
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 17
i am right clicking a non key field in my main form and filtering by a quote number. The key field projectID is tied to the subform by prjId. When i filter, it is not refreshing the subform. I am not seeing any records in the subform. However, when I open the main form it shows all the records in the subforms and i can navigate to the record. Here is the issue, in my sept 1 version there was no problem. In my oct 1st version something has changed and made this problem start. I have spent 6 hours analyzing both versions and cant find what could have changed. i feel like i have looked at all properties and relationships. What could cause this to happen?
WendellB
WendellB
Right there with Babe
Right there with Babe (766 reputation)Right there with Babe (766 reputation)Right there with Babe (766 reputation)Right there with Babe (766 reputation)Right there with Babe (766 reputation)Right there with Babe (766 reputation)Right there with Babe (766 reputation)Right there with Babe (766 reputation)

Group: General Forum Members
Points: 766 Visits: 1758
In order to make suggestions as to what might be going on, it would be helpful to know what version of Access you are using, and what the format of the database is - .MDB, .ADP, .ACCDB, etc. Also, it would useful to know the linkage of the subform control with the main form that it resides within.

Wendell

Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
bdog2607
bdog2607
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 17
thank you. access 2010 and it is an .accdb
WendellB
WendellB
Right there with Babe
Right there with Babe (766 reputation)Right there with Babe (766 reputation)Right there with Babe (766 reputation)Right there with Babe (766 reputation)Right there with Babe (766 reputation)Right there with Babe (766 reputation)Right there with Babe (766 reputation)Right there with Babe (766 reputation)

Group: General Forum Members
Points: 766 Visits: 1758
Are you linking to a SQL Server backend, or are the tables stored in Access as well?

Also, what if anything, changed from September 1 to October 1, other than the data?

Wendell

Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
bdog2607
bdog2607
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 17
all the data is in tables in access. i have been doing access development since 2000 with over 60 projects. i built this database and then handed it over to the client. They asked for changes and i always keep my emails so i had the history. The sept 1 database worked with the right click and filter by non key field and the subform still showed the records after filter. I have a requery macro that runs on activation of subform and it worked. Then the client emailed me the database on october 1st for some changes and after the right click and filter the subform would not refresh the subform. The macro is stiill the same. My linked fields are still good. My relationships in the queries haven't changed. And my properties all look the same. Why would i be asble to see all the subform records when i open the main form but not after filtering by the rightclick?

thank you again
WendellB
WendellB
Right there with Babe
Right there with Babe (766 reputation)Right there with Babe (766 reputation)Right there with Babe (766 reputation)Right there with Babe (766 reputation)Right there with Babe (766 reputation)Right there with Babe (766 reputation)Right there with Babe (766 reputation)Right there with Babe (766 reputation)

Group: General Forum Members
Points: 766 Visits: 1758
This forum may not be the best for pure Access applications. Most people who post here are working with SQL Server back-ends so they aren't that conversant with strictly Access applications. If I'm not able to assist you, I can suggest some other forums that may be able to.

This is probably a long shot, but is it possible that macros are being blocked by Access? There is option under the Trust Center that will do that. Also, Activation may not be the best choice for doing the refresh - OnCurrent may be a better choice. Unfortunately it does have more overhead. I frankly almost never use macros in Access because of the limited ability to debug them. If neither of those possibilities helps, can you post a sanitized and shrunken database that demonstrates the problem - be sure to compact it and then zip it.

Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
bdog2607
bdog2607
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 17
thank you . if you can direct me to an access forum that would be great. I do SQL developemnt as well and just got stuck with this one. So i tried ghere.
thanks for your help
bdog2607
bdog2607
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 17
thank you . if you can direct me to an access forum that would be great. I do SQL developemnt as well and just got stuck with this one. So i tried ghere.
thanks for your help
ProofOfLife
ProofOfLife
SSC-Enthusiastic
SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)

Group: General Forum Members
Points: 106 Visits: 9474
Hi

Just a thought - have you tested to see whether the version which the client sent back for you to change worked?

If you are issung development versions to the client, it is possible that someone has inadvertently changed something prior to you getting it, so looking for a solution in your latest work may not be the correct place to start. This is probably a long-shot and you may very well have checked but I thought it worth suggesting - there is an element of "experience" in this suggestion ;-)

I would start by putting breakpoints on every bit of code I thought was relevant to the opening/loading/refreshing of these forms. I would then be stepping through all the code making sure it is doing what I expected. Perhaps certain events aren't firing in the sequence you think, or perhaps there has been a database change which is causing your refresh query to fail, ... the list goes on Ermm

Another one which comes to mind (again an element of experience) is - are you building and executing a query in your VBA? If you are, use a breakpoint and the Immediate window to capture the sql created and test that.

Other things to check are changes to control or form names, or maybe form referencing.

If none of this helps, I think what would be useful is information on how you have linked the subform to the master and maybe even the code of the right-click event along with any other subs or functions called from it.

Once you get this solved - and you will - I would suggest making sure that for live usage, you compile the front end eliminating any future uncertainty.

I have spent many frustrating hours debugging subforms and functionality driven from them - I hope some of the suggestions above lead you to a solutiion.

Regards

Rowan
WendellB
WendellB
Right there with Babe
Right there with Babe (766 reputation)Right there with Babe (766 reputation)Right there with Babe (766 reputation)Right there with Babe (766 reputation)Right there with Babe (766 reputation)Right there with Babe (766 reputation)Right there with Babe (766 reputation)Right there with Babe (766 reputation)

Group: General Forum Members
Points: 766 Visits: 1758
bdog2607 (11/21/2012)
thank you . if you can direct me to an access forum that would be great. I do SQL developemnt as well and just got stuck with this one. So i tried ghere.
thanks for your help
There are two very active forums, and another that I am aware of. They are
UtterAccess
Windows Secrets Databases
Eileen's Lounge Access/SQL

You might also take a close look at what ProofOfLife suggested, although I believe you are using macros rather than VBA. If that is not the case, then you might post the VBA code that is doing the refresh.

Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search