Navigation Control BrowseTo Error 6054

[Adelina_RO]

Hi people
I return with another question that has me stumped...
I have the following setup:
Main Form (A) -> NavigationSubform with two forms (B and C)
-> SubForm B -> NavigationSubform with two forms (B1 and B2)
-> SubForm C -> NavigationSubform with three forms (C1, C2 and C3)

I have a button on B1 that is supposed to take me to C. I do that using: DoCmd.BrowseToForm , "C", "A.NavigationSubform", which works just fine.
My problem is that on runtime, before opening the A form, i open a hidden timer form (T) which does some periodic checkups, and it seams that if the hidden form is open, the docmd.browsetoform breaks down and gives me the 6054 error. If the T form is closed, the docmd.browseto works again...
Any thoughts would be greatly appreciated
Thank you

 

[Uncle Gizmo]

I noticed your question has yet to receive a reply. It may be because it has been missed, or it could be because it refers to navigation forms which most developers do not entertain. Hopefully you will get a better answer shortly!

 

[The_Doc_Man]

Just as a silly idea, don't do a BrowseTo command. Instead, do a SetFocus.

This article describes .SetFocus and the example explicitly instructs you on how to set focus to a specific control on a specific form.

TextBox.SetFocus method (Access)

Office VBA reference topic

docs.microsoft.com

If you know the name of a targeted control on the targeted form, you should be in business.

 

[Adelina_RO]

Just as a silly idea, don't do a BrowseTo command. Instead, do a SetFocus.

This article describes .SetFocus and the example explicitly instructs you on how to set focus to a specific control on a specific form.

TextBox.SetFocus method (Access)

Office VBA reference topic

docs.microsoft.com

If you know the name of a targeted control on the targeted form, you should be in business.

Thanks but that won;t work in this scenario because the form isn't loaded until the browsetoform command, so there would be no control to set the focus to

 

[arnelgp]

just a thought.
maybe Kill the timer of form T, before doing browseTo.

'kill the timer
[Forms]![T].TimerInterval = 0
DoCmd.BrowseTo ...
'reinstate the timer
[Forms]![T].TimerInterval = somenumber

 

[Adelina_RO]

just a thought.
maybe Kill the timer of form T, before doing browseTo.

'kill the timer
[Forms]![T].TimerInterval = 0
DoCmd.BrowseTo ...
'reinstate the timer
[Forms]![T].TimerInterval = somenumber

I've tried that too. The only thing that worked was to remove all the DLookUps i had going prior to docmd.BrowseTo and that worked. For me, at least i had to write a custom dlookup which works fine if used before the blasted browseto. Thanks everyone for your help