Forms!MyForm.Visible = True not working

[pbaldy]

Try



https://stackoverflow.com/questions/...r-send-to-back

[GraeagleBill]

I am not sure GotFocus event is the best one for what you are trying to do.

What else fires when the user clicks on the down-arrow of the combo?

I understand your description of making the image form Modal. It's the same situation as if I open it Dialog, in which case the user would have to close the image form before any other user action.

[June7]

Why do you need action on click of dropdown? Why not AfterUpdate event?

Have to close or set not visible. Basically same result from user perspective.

Opening with acDialog doesn't seem to be quite the same as setting Modal property. When I use acDialog, can't seem to programmatically set Visible property. I can with Modal property set to yes.

[GraeagleBill]

Why do you need action on click of dropdown? Why not AfterUpdate event?

Because to make the appropriate choice among the dropdown list requires simultaneous viewing of the image, hence pop the image up when the down-arrow is detected.

So, at 4AM this morning I said to myself, "dah self, replace the combobox with bound a text box and put the choice selection right in the image form and open the form dialog!".

[June7]

So user had to click combobox to trigger form popup? I try to build forms so user doesn't have to leave keyboard during data entry.

Glad you found an alternative.

[isladogs]

Bill
You asked me to look at post #12 though you since seem to have found the problem

For info, although it will still work, you don't need the Form in Forms!frmImSample.Form.Visible = True

You can bring an object to the front in design view using DoCmd.RunCommand acCmdBringToFront
Or you need to set focus on the object in a form to bring it to the front: Me.ObjectName.SetFocus

[June7]

AFAIK, DoCmd.RunCommand acCmdBringToFront applies to controls on form, not form itself, and only works when form is in design view:

Me.tbxItemSearch.InSelection = True
DoCmd.RunCommand acCmdBringToFront


In my test, programmatically setting focus on control in form does not bring the form to front.

[davegri]

AFAIK, DoCmd.RunCommand acCmdBringToFront applies to controls on form, not form itself, and only works when form is in design view:

Me.tbxItemSearch.InSelection = True
DoCmd.RunCommand acCmdBringToFront


In my test, programmatically setting focus on control in form does not bring the form to front.

How abou this:

DoCmd.SelectObject acForm, "frmLocal" 'bring to front

[isladogs]

AFAIK, DoCmd.RunCommand acCmdBringToFront applies to controls on form, not form itself, and only works when form is in design view:

Me.tbxItemSearch.InSelection = True
DoCmd.RunCommand acCmdBringToFront


In my test, programmatically setting focus on control in form does not bring the form to front.

Yes- that's what I said in the previous post

[June7]

Yes- that's what I said in the previous post

Yes, I see that now.

However, the issue is about how to bring a form to front of other forms in the app window, not revealing a control on form.