G
Guest
I am trying to call a sub procedures based on the current textbox. The
situation is this; my database receives input from a scale and places the
weights directly into the textbox with the focus. The scale communicates
using MsComm's OnComm event. However, this does not run the
Textbox_AfterUpdate procedure that needs to be run (I don't know why). Since
there are many textboxes that receive weights from the scale, I need it to
run the correct AfterUpdate procedure.
So far I have tried :
dim strTextbox as String
strTextbox = me.ActiveControl.Name & "_AfterUpdate"
call strTextbox
That did not work because access requires a sub procedure so I tried:
dim strTextbox as String
strTextbox = me.ActiveControl.Name & "_AfterUpdate"
application.run strTextbox
This does not work; I guess, because the form is not a public class and the
procedure also is not public.
I might also add that the form that gets the input is a subform.
I need to solve this problem one of two ways. 1, the text box recognizes
that it has been updated and therefore, runs the appropriate sub
automatically; or 2, the OnComm can call the appropriate AfterUpdate
procedure. Any help will be greatly appreciated.
situation is this; my database receives input from a scale and places the
weights directly into the textbox with the focus. The scale communicates
using MsComm's OnComm event. However, this does not run the
Textbox_AfterUpdate procedure that needs to be run (I don't know why). Since
there are many textboxes that receive weights from the scale, I need it to
run the correct AfterUpdate procedure.
So far I have tried :
dim strTextbox as String
strTextbox = me.ActiveControl.Name & "_AfterUpdate"
call strTextbox
That did not work because access requires a sub procedure so I tried:
dim strTextbox as String
strTextbox = me.ActiveControl.Name & "_AfterUpdate"
application.run strTextbox
This does not work; I guess, because the form is not a public class and the
procedure also is not public.
I might also add that the form that gets the input is a subform.
I need to solve this problem one of two ways. 1, the text box recognizes
that it has been updated and therefore, runs the appropriate sub
automatically; or 2, the OnComm can call the appropriate AfterUpdate
procedure. Any help will be greatly appreciated.