Hello all,
I have a form that displays results of a query based on SaleID. If I try onClick event (on that ID), it will go correctly to that\record, but I'm unable to move back and forth from that record. It is displayed as "filtered" at the bottom bar. Is there a way to use DoCmd.BrowseTo so that I'd be able to move (once changes are done) back and forth without leaving the form (frmSales in my example). Does it have anything to do with DataMode?
I have a form that displays results of a query based on SaleID. If I try onClick event (on that ID), it will go correctly to that\record, but I'm unable to move back and forth from that record. It is displayed as "filtered" at the bottom bar. Is there a way to use DoCmd.BrowseTo so that I'd be able to move (once changes are done) back and forth without leaving the form (frmSales in my example). Does it have anything to do with DataMode?
Code:
Private Sub SaleID_Click()
DoCmd.BrowseTo ObjectType:=acBrowseToForm, _
ObjectName:="frmSales", _
PathToSubformControl:="frmNavigation.frmNavSub", _
WhereCondition:="[ID] = " & Me!SaleID ', _
End Sub