Hello Everyone.
I have a form that has a subform in it. The form header contains a textbox that has the purpose to search the subform. And I need to keep track of the last time that a search was made. I need to make this process automatic. So what i have done is the following:
textbox on header has the following:
then another textbox on the subform has the followin:
after this I need to set focus on a button on the same subform
I tried doing this using Afterupdate on lastsrch, but I can´t find a way to do so.
Can anyone shed some light on this?
Thanks to everyone in advance.
Cheers.
I have a form that has a subform in it. The form header contains a textbox that has the purpose to search the subform. And I need to keep track of the last time that a search was made. I need to make this process automatic. So what i have done is the following:
textbox on header has the following:
Code:
Private Sub srchnum_AfterUpdate()
DoCmd.Requery "query srchnum subform"
Me.query_srchnum_subform.SetFocus
Me.query_srchnum_subform![lastsrch].SetFocus
End Sub
then another textbox on the subform has the followin:
Code:
Private Sub lastsrch_GotFocus()
Me.lastsrch = Now
End Sub
after this I need to set focus on a button on the same subform
I tried doing this using Afterupdate on lastsrch, but I can´t find a way to do so.
Can anyone shed some light on this?
Thanks to everyone in advance.
Cheers.