I would like to call a sub routine that is in a sub form from the main forms Form_Current event. I have a field that is calculated and I would like to update it when a change to the data has occured on the main form. I am having trouble finding information on this. I tried making the sub Public but that didn't work, but I don't know if my sintax was the problem or what. Any help would be appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Calling a Sub Routine in a subform from the main form 1
- Thread starter turbosrl
- Start date
MarkWright
Programmer
Hello,
I call 1 form and then call another form from a button. I enter data in the second form and by closing I use -->
Forms.Item("frmPBS_Testzyclus"
.Refresh
to see the information change in the first form. You can use something like this by calling the formular field and and refreshing it.
Just a thought.
Mark
I call 1 form and then call another form from a button. I enter data in the second form and by closing I use -->
Forms.Item("frmPBS_Testzyclus"
.Refreshto see the information change in the first form. You can use something like this by calling the formular field and and refreshing it.
Just a thought.
Mark
-
1
- #3
SkipVought
Programmer
Hi,
I usually put commonly called routines in a module.
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
I usually put commonly called routines in a module.
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question