DblClick SubForm - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

DblClick SubForm

Elisabeth Koivumaa

5 years ago

I have a form where I click to open another form in a new window. In this form I have a subform and when I double click in it to open an order I want it to open in a new window, but that form ends up in the background (behind the second form)
How do I double-click the page I want to open in a new window?

Hope you understand what I mean?

	Richard Rost @Reply 5 years ago
Sounds like you have your open event in the OnClick instead of the OnDblClick

	Elisabeth Koivumaa OP @Reply 5 years ago
Private Sub SearchResults_DblClick(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As String stDocName = "Inventory_Ta_Emot_Order" stLinkCriteria = "[OrderNr]= " & Me![SearchResults] DoCmd.OpenForm stDocName, , , stLinkCriteria End Sub

	Richard Rost @Reply 5 years ago
So it's opening the right form, but then putting it immediately in the background? That's odd. See if it works in the OnClick event instead.

	Elisabeth Koivumaa OP @Reply 5 years ago
No it did not help.

	Richard Rost @Reply 5 years ago
Do you have any other code on the first form that might be forcing it back to the foreground? Without seeing your whole database, it's very hard to troubleshoot. Does this happen in a blank new database, or my Blank Template? It shouldn't. Something is amiss.

	Elisabeth Koivumaa OP @Reply 5 years ago
I solved the error. Have struggled for so long and now I fixed it. I added ,, acDialog after stLinkCriteria. Have tried before but did not get it then. Happy

	Richard Rost @Reply 5 years ago
As long as you got it working, I'm happy too. :)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View