So is it possible to have a subroutine where the code gets to a certain point/condition whereby you could jump back to a specific point in the subroutine? Or perhaps jump from one subroutine to another and back again?
So is it possible to have a subroutine where the code gets to a certain point/condition whereby you could jump back to a specific point in the subroutine? Or perhaps jump from one subroutine to another and back again?
Sure, both are possible. More info about what you're trying to achieve will probably yield the best response. You can use GoTo to send code to a specific spot, though it's considered bad practice to use it much (spaghetti code). If you call a sub/function code will go perform that process then return.
what would be the syntax for calling another subroutine in the same module?
module is [Form_FrmFTLoop]
Private Sub BtnSearch_Click() calls Private Sub Form_AfterUpdate()
I figured it out....
within Private Sub BtnSearch_Click() write:
Form_AfterUpdate
Glad you got it working. Personally if something needs to be called from multiple places I'll create a sub/function and call it from those places.