<div>
<i>to the original settings when a person starts to type in the textbox:</i><br />
I don't know that that is REALLY what you want, and the correct description of when<br />
BUT...<br />
If that is truly correct then GotFocus() is your baby.<br />
<br />
If what they are typing in needs to be complete and important, then you have one good choice and one necessary evil.<br />
The good choice is AfterUpdate() which happens when they LEAVE that field -- and sometimes that takes a button or some setup to MAKE the user leave the field.<br />
The necessary evil is if you DON'T or CAN't make them leave the field.<br />
Then you need a Change() event that looks at the sting as they type it in, one character at a time, and does stuff when a valid string (or partial string) is completed by the keystroke just registered.
</div>


<div>
NICK67,<br />
&quot;The necessary evil is if you DON'T or CAN't make them leave the field.<br />
Then you need a Change() event that looks at the sting as they type it in, one character at a time, and does stuff when a valid string (or partial string) is completed by the keystroke just registered.&quot;<br />
<br />
This is exactly my intention.<br />
the problem is the requery takes along time.<br />
<br />
These folks want to see all the records before doing any searching.<br />
I just need to reset the link once to initiate the search. and relink. somehow.<br />
<br />
fordraiders
</div>


<div>
very good..razzle dazzle is my thinking also.<br />
thanks..!!
</div>


<div>
Did that behave well for you?<br />
It struck me as a good way to get after it, but that doesn't necessarily mean it was good :)
</div>


<div>
It was a good suggestion<br />
Yes
</div>


<div>
<div class="content wysiwyg-content">
access 2010 &nbsp;vba.<br />
<br />
When i open a bound form, <br />
I have a subform that i'm resetting the master child source to &nbsp;&quot;&quot;<br />
<br />
Forms!frmMainDataEntry![Sa<wbr />pData subform].LinkMasterFields = &quot;&quot;<br />
Forms!frmMainDataEntry![Sa<wbr />pData subform].LinkChildFields = &quot;&quot;<br />
<br />
I'm doing this to see the subform , initially on startup, &nbsp;to see all the records in the subform.<br />
<br />
What I need: <br />
I have a textbox that I'm using to search into the subform.<br />
<br />
I then need to reset the subform to the original settings when a person starts to type in the textbox:<br />
I just dont know what property is the best to do this and when.<br />
<br />
&nbsp;Forms!COSTRECOVERY_MAINFOR<wbr />M![WR294_G<wbr />RIDVIEW subform].LinkMasterFields = &quot;Search_Term_Holder&quot;<br />
&nbsp;Forms!COSTRECOVERY_MAINFOR<wbr />M![WR294_G<wbr />RIDVIEW subform].LinkChildFields = &quot;Customer Name&quot;<br />
<br />
i TRIED THE TEXTBOX before update event but i keep getting an error.
</div>
</div>


access 2010  vba.

When i open a bound form, 
I have a subform that i'm resetting the master child source to  ""

Forms!frmMainDataEntry![SapData subform].LinkMasterFields = ""
Forms!frmMainDataEntry![SapData subform].LinkChildFields = ""

I'm doing this to see the subform , initially on startup,  to see all the records in the subform.

What I need: 
I have a textbox that I'm using to search into the subform.

I then need to reset the subform to the original settings when a person starts to type in the textbox:
I just dont know what property is the best to do this and when.

 Forms!COSTRECOVERY_MAINFORM![WR294_GRIDVIEW subform].LinkMasterFields = "Search_Term_Holder"
 Forms!COSTRECOVERY_MAINFORM![WR294_GRIDVIEW subform].LinkChildFields = "Customer Name"

i TRIED THE TEXTBOX before update event but i keep getting an error.

resetting the master child  links in the right place

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.