Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

refreshing subform after right click and filter field in main form Expand / Collapse
Author
Message
Posted Wednesday, November 21, 2012 8:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 28, 2012 3:53 PM
Points: 5, Visits: 14
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?
Post #1387444
Posted Wednesday, November 21, 2012 8:58 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 17, 2014 6:41 AM
Points: 139, Visits: 509
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!
Post #1387467
Posted Wednesday, November 21, 2012 9:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 28, 2012 3:53 PM
Points: 5, Visits: 14
thank you. access 2010 and it is an .accdb
Post #1387469
Posted Wednesday, November 21, 2012 9:47 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 17, 2014 6:41 AM
Points: 139, Visits: 509
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!
Post #1387497
Posted Wednesday, November 21, 2012 10:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 28, 2012 3:53 PM
Points: 5, Visits: 14
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
Post #1387513
Posted Wednesday, November 21, 2012 11:20 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 17, 2014 6:41 AM
Points: 139, Visits: 509
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!
Post #1387536
Posted Wednesday, November 21, 2012 11:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 28, 2012 3:53 PM
Points: 5, Visits: 14
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
Post #1387552
Posted Wednesday, November 21, 2012 11:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 28, 2012 3:53 PM
Points: 5, Visits: 14
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
Post #1387563
Posted Wednesday, November 21, 2012 7:47 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 4:34 PM
Points: 48, Visits: 9,470
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

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
Post #1387665
Posted Thursday, November 22, 2012 10:03 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 17, 2014 6:41 AM
Points: 139, Visits: 509
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!
Post #1387944
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse