Table already open ...

[Steff_DK]

Hi all,
I have a form with a tab ctrl with several pages in it. Some of the pages get data from DIFFERENT queries that get data in the SAME table. I get an error when I open the form, since the first time a form is open - or a query is run, it doesn't "close the connection" to the table again.

What do I do???

Any help is highly appreciated

 

[RuralGuy]

Are you using SubForms on the different tab pages to display the data from the various queries? There should be no problem or conflict running several queries that reference the same table. I suspect something else is going on to cause the error you mentioned.

 

[Steff_DK]

Yup - one subform, with one more subform on each page of the tab ctrl.
But only one form open for edit for each table. Most of the forms contain calculated fields anyway, so they cannot be edited... Funny thing is, though, that the table causing trouble is not being accessed by any form or query whatsoever!
I do 4-5 DLookup to the table, on main form load, and that's it... ????????

Any golden rules regarding lots of forms with subforms open at the same time?

Thanks!

 

[Steff_DK]

Okay problem solved.
2 forms with same table as source.

In my "users" table I have a field called LastSeen with the date, where a given user last accessed the DB. The value was updated by a hidden textbox on the main form when the user opened the DB. I Moved the hidden textbox to the other form where the rest of tha data from "users" table were being handled ...

Ever lost track of a project??

 

[RuralGuy]

Excellent! Glad you found the problem.