Make form Visible in a Navigation pane

[carmenv323]

I have a Menu form (picture attached) - so you
1) click on Finish an Incomplete Request
2) Select the request from the dropdown
3) Make the form visible so they can edit.

What's happening is that in my code I was originally using an OpenForm command and it's opening the form in a new tab, but what I want is to make the form visible with the filter in place. Where do I need to change my code to do this?

Private Sub cboSelectInc_AfterUpdate()
 
    Dim ProjNo As String
    Dim ProjFilter As String
 
    ProjNo = Me.cboSelectInc
    ProjFilter = "txtProjectNumber = '" & ProjNo & "'"
 
    DoCmd.OpenForm "frmIncRequestsQ", acNormal, "FilterInc", ProjFilter
    Forms![frmIncRequestsQ].Visible = True
   
    DoCmd.Close acForm, "MainMenu" 
 
End Sub

[CJ_London]

not sure what you mean by 'make the form visible with filter in place'. Do you mean as a popup?

don't know what FilterInc is, it should be a query

but all you should need is

DoCmd.OpenForm "frmIncRequestsQ", acNormal, "FilterInc", "txtProjectNumber = '" & Me.cboSelectInc & "'"

and if you want to open as popup


DoCmd.OpenForm "frmIncRequestsQ", acNormal, "FilterInc", "txtProjectNumber = '" & Me.cboSelectInc & "'",,acDialog

[Micron]

Why not just use the query to filter to whatever the filter is doing?

[carmenv323]

I don't understand what you mean about the query filter....

The unbound box is the cboSelectInc which allows the user to select the estimate to continue working on - in the AfterUpdate Event I have the code to open the form to the selected estimate and this works fine in opening the form to the correct record using the filter. By the way, I updated the code to the suggested DoCmd.OpenForm "frmIncRequestsQ", acNormal, "FilterInc", "txtProjectNumber = '" & Me.cboSelectInc & "'" and it gives me the same results in opening the form separately instead of in the same form.

Let me explain: Under the "Finish an Incomplete Request" drop down, I added the form that I want to "make visible" so the form is sitting there I just want it to become visible to the selected record instead of opening separately on a different tab. I think the issue is in the DoCmd.OpenForm, I tried to add a code to Forms![frmIncRequestsQ].Visible=True before the OpenForm event and it doesn't work either.

Is this doable?

[Micron]

I think you're describing a subform situation. Not sure why you'd show so little of the form if that's what you're trying to make visible. In that case, you don't open this form, you hide and unhide the subform control.

[carmenv323]

These are the screenshots, I basically dragged the form into the other form. Should I be changing the default view? How do I un/hide the control while still filtering?

[Micron]

In design view change the subform control visible property to no. Open then filter the subform then unhide the control and see what you get for records. Close form and repeat with a different filter and see what you get. If you cannot filter the form then unhide it and show the records you want I'll be surprised. No need to change the default view of the subform for this.

Not real sure what's going on yet. Posts 2 and 5 indicate some uncertainty about the requirement and I don't think they've been addressed. I don't want to take you down the wrong path with this visible/invisible subform thing if that isn't the issue.

[CJ_London]

How do I un/hide the control while still filtering?

you use the visible property of the subform

instead of docmd.openform you use me.[Estimate Request Form].visible=true

Note that making a subform control visible does not requery the form object it contains. There are a number of ways this can be done but the easiest is to set the subform linkmaster property to cboSelectInc and the linkchild property to FilterInc then no code is required

Note having spaces in object (such as fields, controls, tables, forms, reports) names is a bad idea, requires extra typing and increases the opportunity for errors. You will be told this pretty much every time you post a question. For example in your first post you close form "MainMenu" but the form is actually called either "Main Menu" or "Main_Menu" - sometimes access will replace a space with and underscore.

[carmenv323]

I was able to fix the issue with the form actually appearing with the Me.Estimate_Request_Form.Visible = True however, I couldn't connect it to cboSelectInc because the only options are the actual field names, the cboSelectInc is unbound and contains two fields, number & title but only the title is viewable. Is that something I can do in the VBA?

[CJ_London]

The wizards are limited - just type cboSelectInc into the property

[carmenv323]

Thank you Ajax!!!