[AccessDevelopers] Issue with Pivot Table form based on pass-through query

 

Hi all,

I'm interested if anyone might shed some light on an issue that has perplexed me for the past 2 days. My company has Access 2007.

I created a SQL pass-through query in an accdb file with an ODBC connection string embedded in the properties, and then created a pivot table form based on that query. I added the 5 fields to the pivot table, formatted a few things, and was done.

In testing, I found that when I open the form the first time, it displays normally. But if I subsequently click the Refresh button on the ribbon, the query appears to run (status bar messages), but the fields that were placed on the form disappear. This requires adding the fields to the form again to display the data after every Refresh event. This isn't an issue except it's built for Access novices.

Anyone familiar with any limitations on pass-throughs, or perhaps the order of events that might not be what I expect?

Thanks

Brian

__._,_.___

---

Posted by: bribielick@yahoo.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Yahoo Groups

New Feature! Add Polls to Conversations

You can now include a poll directly within your message. Members can view, vote and add poll options either via email or on the group. Try it today!

---

Did You Know?

Learn more about how to search within your groups.

---

Please zip all files prior to uploading to Files section.

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___