V
vdha via AccessMonster.com
Hello Everybody
I have looked for existing thread on this one but could not find my answer.
Here is my problem
I have a main form and several subforms. One is Review and the other is Date
In the review form I have a button that will send a report but I need to
stamp the date when it was done and all my dates are in the "Date" subform.
SO I need a VB code within the SendReport_OnCLick to go from the review form
to the date form and then do
reviewdate = now()
I tried
Forms. Main.Date.SetFocus (That works)
Me!ReviewDate = Now() (That doesn't work)
Forms. Main.Review.SetFocus
But it doesn't recognize the ReviewDate
I can do this kind of thing if I am within the same form but I have never
been able to perform oprations across different subform.
One more thing, all my subform are based on queries in which I call a common
value on the main form .(don't know if that makes a difference)
Let me know if there is a way.
Thanks
I have looked for existing thread on this one but could not find my answer.
Here is my problem
I have a main form and several subforms. One is Review and the other is Date
In the review form I have a button that will send a report but I need to
stamp the date when it was done and all my dates are in the "Date" subform.
SO I need a VB code within the SendReport_OnCLick to go from the review form
to the date form and then do
reviewdate = now()
I tried
Forms. Main.Date.SetFocus (That works)
Me!ReviewDate = Now() (That doesn't work)
Forms. Main.Review.SetFocus
But it doesn't recognize the ReviewDate
I can do this kind of thing if I am within the same form but I have never
been able to perform oprations across different subform.
One more thing, all my subform are based on queries in which I call a common
value on the main form .(don't know if that makes a difference)
Let me know if there is a way.
Thanks