Close Table

User avatar
burrina
4StarLounger
Posts: 550
Joined: 30 Jul 2014, 23:58

Close Table

Post by burrina »

Why would it be necessary to close a table? I have noticed that if I open a report that uses one table , close the form and try to open another form or report the data does not show up. If I close and re-open it display?

Any reason why?
Of course I can release that table but wanted to know why!

User avatar
HansV
Administrator
Posts: 78241
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Close Table

Post by HansV »

I don't understand "I have noticed that if I open a report that uses one table , close the form and try to open another form or report the data does not show up. If I close and re-open it display?" Is this about a form or a report? And you mention that you close something in both sentences.
Best wishes,
Hans

User avatar
burrina
4StarLounger
Posts: 550
Joined: 30 Jul 2014, 23:58

Re: Close Table

Post by burrina »

It's a Report. Weekly Misc Report, open all is well. YTDMisc Report,open after weekly, no data. Close and re-open and data displays

User avatar
HansV
Administrator
Posts: 78241
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Close Table

Post by HansV »

Is this the sequence?
1. Open Weekly Misc Report and leave it open.
2. Open YTDMisc Report. No data displayed.
3. Close YTDMisc Report.
4. Open YTDMisc Report again. Data displayed.
Best wishes,
Hans

User avatar
burrina
4StarLounger
Posts: 550
Joined: 30 Jul 2014, 23:58

Re: Close Table

Post by burrina »

NO. I close the weekly Report then open the Year to Date and no data is displayed. They both use the same table, tblMiscChecks
Both have No Locks on the report.

User avatar
burrina
4StarLounger
Posts: 550
Joined: 30 Jul 2014, 23:58

Re: Close Table

Post by burrina »

Issue has been resolved. Problem was caused by referring back to the main form from the report.
Thanks,