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!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Refreshing A Report on a SQL Server ? 2
- Thread starter Recce
- Start date
![[pipe]](/data/assets/smilies/pipe.gif "[pipe] [pipe]")
"We know nothing but, that what we know is not the truth..." - Me-
1
- #2
ZmrAbdulla
Technical User
Using Access as front-end to SQL Server faq183-2320
may be helpful
________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.
may be helpful
________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.
-
1
- #3
The recordsource behind a report should show up-to-date data when you open it. It is never refreshed unless you close/re-open the report.
If the report is based on a temp table or a 'dummy' table which is loaded via some stored procedure, that's a different story and of course that proc. has to be rerun--but typically this would be part of the code behind your 'Open Report' button on whatever form you use.
--Jim
If the report is based on a temp table or a 'dummy' table which is loaded via some stored procedure, that's a different story and of course that proc. has to be rerun--but typically this would be part of the code behind your 'Open Report' button on whatever form you use.
--Jim
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question
