Forms, Tabs, Subforms... Trouble Shoot Non Updateable Recordset

[Roger]

I have one form with 15 tabs. Each tab has a subform or even a form with a
subform.

When the main form loads all the other forms are also loading as they all
have queries attached to them. I see in the status bar while loading a
message about a recordset is not updateable.

What is the easiest way to see what form this occurs on?

Thanks,

Rog

 

[Rick Brandt]

I have one form with 15 tabs. Each tab has a subform or even a form
with a subform.

When the main form loads all the other forms are also loading as they
all have queries attached to them. I see in the status bar while
loading a message about a recordset is not updateable.

What is the easiest way to see what form this occurs on?

Try to make an edit in each one?

Also; you can remove the SourceObject property from all of the subform
controls on the pages except for page one and set them in the Change event
of the TabControl. That way a subform is not loading its data until and
unless you actually look at it. Saves a lot of time at form load.

 

[John Vinson]

What is the easiest way to see what form this occurs on?

Open the Forms window, and open each form you're using as a subform in
succession.

I don't know any way to trap the error while the forms are opening.

John W. Vinson[MVP]