'Microsoft Access - Navigation form is causing my query to not work

I got a form that works amazingly by itself, but the second I attach it to my navigation form. I start to get prompted for user input since this line

[Forms]![frm_addReceiveReportInformation]![cbo_PurchaseOrderID]

no longer works due to the current form becoming subform in the navigation form which was explained in ACCESS 2010 Navigation Form Query Property

I can't seem to figure a way out of using the !form since I absolutely need to retrieve the ID from a combo box to update another combo box.

I tried multiple ways of using the !forms but I can't seem to wrap my head around how to retrieve my information that I am seeking.

I got the 2 way navigation menu(vertical + horizontal tabs). Anyone got advice or has encounter this problem in the pass, who can direct me down the right path.

enter image description here

sqlformsms-accessms-access-2010


Solution 1:[1]

In order for queries that contain form references to work, the form must be fully loaded. I think the problem you are experiencing is that the query in the Row Source of the Part Code combo is being evaluated before the form is loaded and therefore you are being asked to input the parameter value.

You can work around this by leaving the Row Source property of the Part Code combo empty until it gets focus for the first time, something like:

Private Sub cboPartCode_GotFocus()
  If Len(cboPartCode.RowSource) = 0 Then
    cboPartCode.[RowSource] = "Your Query"
    cboPartCode.Requery
  End If

End Sub

Solution 2:[2]

I sometimes just put a button on the navigation form which opens the desired form as a standalone form. It is probably not the neatest solution but it does work.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 ron tornambe
Solution 2 Graham_C

Related Questions