Recent content by AFrost

Judging by that post, having lazy loading of forms/subforms might help too. I think I have solved my problem using lazy loading of the sub-forms. I have left the sub-form controls unbound and assigned the Sub-Form's Source Object only when the tab containing the sub-form is opened. I have...

Indeed, I have closed them and removed them from memory using the code you have put above. I dearly wish this was the answer to my problem but it doesn't seem to be....:(

Hello all, I am using an Access 2007 front end linked to an Access 2007 back end. I have a Report that the user operates by selecting the information he/she wants to see on a pop-up form and clicking a button. The Report works perfectly unless another form, called Shows Form, in the database...

Hi all, I have a query in which I am ranking artists who are assigned to shows. Here is the query: SELECT qryPS1TeamsFilter.ShowID, qryPS1TeamsFilter.ShowName, tblArtists.FirstName, tblArtists.LastName, (select count(*)+1 from [qryShowsArtists] as b WHERE [qryPS1TeamsFilter].ShowID =...