Navigation Form

[sparker75]

Hello,

I have created a tabbed Navigation Form and added a Navigation Target to a tabular form. In this list I have made a cell (Orders) that when clicked it will open up another form showing the details of that order.

When I do this I get a "Enter Parameter Value" dialogue box.



Is it possible to have a form open over top of another form in a Navigation Form?

See examples

[Minty]

Assuming you have used the inbuilt navigation forms, this is caused by your form being loaded as a subform of the navigation form.

The correct syntax you need will be something like

[Forms]![Navigation Form]![NavigationSubform].Form![YourFormName].[YourControlName]

This is one of the reason most of us don't use them. They add a level of complexity that isn't necessary.
A complete reference to forms and sub forms controls is here http://access.mvps.org/access/forms/frm0031.htm in case I'm a bit off with the syntax... (Quite possibly)

[June7]

Post your attempted code.

If the code is in the form module used as Navigation subform, simple reference should work, does for me.

DoCmd.OpenForm "formname", , , "fieldname =" & Me.fieldname

[sparker75]

Thank you June7. My issue is that the form that opens has a subform.

DoCmd.OpenForm "frmWorkOrder", , , "OrderNum =" & Me.OrderNum This opens the main form frmWorkOrder.

but frmWorkOrder has a subform called frmWordOrderReview

[June7]

Presence of subform shouldn't matter. I open form containing subform.

Is that a typo in post or is the subform name actually using Word?

[sparker75]

Word was a Typo. The subform is filtering on a query criteria using [Forms]![frmWorkOrderStatus]![OrderNum]

This is the error I get

[June7]

Why? Why aren't you using Master/Child Links properties of subform container control?

I never use dynamic parameterized query.

[sparker75]

I'm learning

[June7]

Does that resolve issue?

[sparker75]

Yes this is exactly what I was looking for. Thank you!