Hello
Can anyone help
I have a number of after update events on my form that increment a counter called 'Status Count' which is one of the fields on my underlying table
I would like to set up an action on the forms 'on open' event that goes to the particular private sub when status count is a particular value
For example it would go something like
if Status Count =2 then Call Private Sub Control_A_After Update
I am not sure if its a goto or call and am not sure of the coding or syntax so any help would be appreciated
Thanks
Can anyone help
I have a number of after update events on my form that increment a counter called 'Status Count' which is one of the fields on my underlying table
I would like to set up an action on the forms 'on open' event that goes to the particular private sub when status count is a particular value
For example it would go something like
if Status Count =2 then Call Private Sub Control_A_After Update
I am not sure if its a goto or call and am not sure of the coding or syntax so any help would be appreciated
Thanks