November 21, 2012 at 8:13 am
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?
November 21, 2012 at 8:58 am
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!
November 21, 2012 at 9:03 am
thank you. access 2010 and it is an .accdb
November 21, 2012 at 9:47 am
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!
November 21, 2012 at 10:22 am
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
November 21, 2012 at 11:20 am
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!
November 21, 2012 at 11:38 am
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
November 21, 2012 at 11:55 am
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
November 21, 2012 at 7:47 pm
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
November 22, 2012 at 10:03 am
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
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!
November 23, 2012 at 2:52 am
Every tried to requery the form after you applied the filter?
Example:
Me.YourSubformControlNameHere.Form.Requery
Let me Google that for you:
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply