Form SearchField object and it's events

[FredCailloux]

When you create a brand new form with the Access Wizard, data from the linked table magically appear. That newly created form have a Search Field on the bottom. It is very useful and efficient. I need to run a VBA code when the user access that search field. I have been looking substantially on the Form.Events list in the properties window and could not find any events corresponding to that search field. Furthermore, I cannot find any properties specific to that object. The Access VBA help doesn't mention anything about it either ( I could not find any). Clearly, Access offer so many events connected to all the Form objects and the Form itself, there has got to be some Events triggered by that search field.:banghead:

How can I access the Form Search Field and or it's Events via VBA ?

Much appreciation for your help

 

[Ranman256]

When you select the text box,
Look at the properties,
Click the EVENT tab, there are no events listed?
?????

 

[FredCailloux]

Thanks Ranman, No, there are no properties for that object because it does not appear in the Property window DropDown selector. The object I am referring to
(if it is an object ?) is the search field on the very bottom of the Form. It is not an object that I have put there myself, it is intrinsically present when you create a Form. And that Search field does not appear as an object when in Creation mode. It is precisely situated on the right site of the Record selector and Filter tool at the very bottom of the Form. And I cannot find any way to select that object when in Creation mode. It does not appear in that mode.

After further research I found that if VBA send the command

Me.NavigationButtons = False

those navigation button controls disappear and with them so is the SearchField. Conclusion the whole gang (navigation buttons, Filter and SearchField) are one only object. Now I need to find how to control the content of that SearchField.

 

[jdraw]

?? I'm not sure that you can access or use any events associated with that search field. It was cretaed by means f the wizard. I just created such a form and in design view I do not see anything for that search field.
When you add a Control to a Form, such as a textbox (for your search term) there definitely is/are events associated with your Control. Such events will be the default events for that type of Control.

Others may have more info.

Good luck.