I am hoping for some Forum Magic. Every time I have posted a problem here I have found the answer within a few minutes of the posting. so Here it goes.
I have a form that is used to edit order.
On the main Form I have a tab control.
On one of the pages(ITEMS) of the tab control I have a sub form that allow the users to page through the items on the order and make changes. Every thing works fine except on the Custom navigation button I created. When the user select the ITEMS tab the subform is displayed but the box that should display "Record 1 of #" do not display. if I go to the next record it displays correctly.
I have tried setting watch points in my code and it seem that the oncurrent event is not triggering when the user selected the order to edit on the main from. I have tried to set the caption of this button in the onclick event for the tab control.
Code:
Private Sub TabCtl71_Change()
Select Case Me!TabCtl71.Value
Case 0
MsgBox ("order infor")
Case 1
MsgBox ("buyer info")
Case 2
MsgBox ("items")
Me![edit_order_items_subform].Form!tblreccount.Caption = _
"Record " & Me.[edit_order_items_subform].Form.CurrentRecord & " of " & _
Me.[edit_order_items_subform].Form.RecordCount
Case 3
MsgBox ("adjust")
Case 4
MsgBox ("returns")
End Select
then this tries to execute I get this error
"runtime error 2465 application defined or object defined error"
The code that I have in the oncurrent event work great when it fires but I cannot figure out a way to cause it to fire.
