Hi all
I have got a main for with a sub form as shown below named below
FrmMainDetails - Main From
SFrmNewOrders - Sub Form From FrmMainDetails
SSFrmBackOrders - Sub Form From SFrmOrders
What I want is a footer on the main from so I can go through the relevant records and not make it look really untidy on the actual forms, how do I get navigation buttons to go through Next, Previous and new for both sub forms?
I tried the below code, this works for the SFrmOrders but not SSFrmBackOrders
The other issue I have is when you click too far an error Debug message appears, I just want a notice to say "no more records avaliable" or simular
I have got a main for with a sub form as shown below named below
FrmMainDetails - Main From
SFrmNewOrders - Sub Form From FrmMainDetails
SSFrmBackOrders - Sub Form From SFrmOrders
What I want is a footer on the main from so I can go through the relevant records and not make it look really untidy on the actual forms, how do I get navigation buttons to go through Next, Previous and new for both sub forms?
I tried the below code, this works for the SFrmOrders but not SSFrmBackOrders
The other issue I have is when you click too far an error Debug message appears, I just want a notice to say "no more records avaliable" or simular
Code:
[SFrmNewOrders].SetFocus
RunCommand acCmdRecordsGoToNext