Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Refresh pivot table forms on open

Status
Not open for further replies.
Mikeauz

Mikeauz

Technical User
Joined
Jul 23, 2002
Messages
75
Location
AU
Hi,

I've created a pivot table form using the pivot table wizard in forms (Access 2000) but haven't had much luck in getting the pivot table to refresh when it's opened...

I've tried putting a .refresh line in the command button but it doesn't work and creates an error about pasting...

Any ideas?
 
Status
Not open for further replies.

Similar threads

kingz2000
  • Locked
  • Question Question
Bound/unbound forms
Replies
2
Views
901
dhookom
dhookom
breezett93
  • Locked
  • Question Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
2K
dhookom
dhookom
applestoapples
  • Locked
  • Question Question
Make Table Query sort not working
Replies
2
Views
492
Andrzejek
Andrzejek
Dophia
  • Locked
  • Question Question
Problem using code to open a form, but works to open a report
Replies
1
Views
330
dhookom
dhookom
applestoapples
  • Locked
  • Question Question
Create duplicate rows based on Qty field
Replies
7
Views
630
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top