resetting the master child links in the right place

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.
LVL 3
FordraidersAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Nick67Commented:
to the original settings when a person starts to type in the textbox:
I don't know that that is REALLY what you want, and the correct description of when
BUT...
If that is truly correct then GotFocus() is your baby.

If what they are typing in needs to be complete and important, then you have one good choice and one necessary evil.
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.
The necessary evil is if you DON'T or CAN't make them leave the field.
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.
0
FordraidersAuthor Commented:
NICK67,
"The necessary evil is if you DON'T or CAN't make them leave the field.
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."

This is exactly my intention.
the problem is the requery takes along time.

These folks want to see all the records before doing any searching.
I just need to reset the link once to initiate the search. and relink. somehow.

fordraiders
0
Nick67Commented:
I would look at a little legerdemain then.
These fools want to see all the records first, and then see the bound subform, correct?

I would try putting TWO subforms on the form.
One right on top of another.
One unbound.
The other bound.

When they do the thing that signals they are done with the unbound one, you make it Visible = False and the bound one Visible = True.  And vice versa.

Then you aren't waiting on any kind of requery.
It's worth exploring for feasibility
Change() events are a bitch, and you REALLY want to avoid going there.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

FordraidersAuthor Commented:
very good..razzle dazzle is my thinking also.
thanks..!!
0
FordraidersAuthor Commented:
thnx
0
Nick67Commented:
Did that behave well for you?
It struck me as a good way to get after it, but that doesn't necessarily mean it was good :)
0
FordraidersAuthor Commented:
It was a good suggestion
Yes
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.