Hi Guys, Thanks for the feedback on this, still not been able to find where this is located, but having the same problem with a form, again copied from existing to keep consistency.
When I open the form the parameter box is showing, see image:
I can see the form is showing as filtered, the filter value is from the form that calls it with the following code:
Code:
Private Sub cmdOrderEdit_Click()
DoCmd.SetWarnings False
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmOrderDispatchEdit"
DoCmd.OpenQuery "TempCustomerPriceCheckDispatch"
stLinkCriteria = "[CustID]=" & Me![CustID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
Forms!frmOrderDispatchEdit!accountID = accountID '.Value
Forms!frmOrderDispatchEdit!txtcustID = CustID '.Value
Forms!frmOrderDispatchEdit!txtaddress1 = Address2 '.Value
Forms!frmOrderDispatchEdit!txtaddress2 = Address1 '.Value
Forms!frmOrderDispatchEdit!txtaddress3 = Address3 '.Value '
Forms!frmOrderDispatchEdit!txtName = CustName '.Value
Forms!frmOrderDispatchEdit!txtpostcode = Post_Code '.Value
Forms!frmOrderDispatchEdit.SetFocus
End Sub
When I select ok on the parameter box and close it, the form opens and works fine with totals and footer buttons:
any suggestions where I can look to find this info would be appreciated.