Subdatasheet problem

[Guest]

I have a 3 prompts before opening my main form. These 3 prompts will
automatically update the combo boxes in the main form and requery the subform
and subdatasheet in the Main form. I then use code in the 3rd prompt module
that runs a sub procedure in the main form module. This sub procedure in the
main module reorders the columns in the subdatasheet. The problem is when I
run the sub procedure from the 3rd prompt module, the subdatasheet will open
and be hidden. Not sure why the subform becomes hidden, if I leave out the
sub call from the 3rd prompt, the subform will not be hidden and everything
works great. Why is the code opening and hiding my subform? The code does
not affect the subform when it is hidden.

 

[James Hahn]

By 'hidden' do you mean that it is overlayed by the main form? This will
happen if the sub call causes focus to be transferred to the main form. The
simplest solution is to add a command to the sub call that shifts the focus
back to the sub datasheet.