Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 47
  • Last Modified:

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.
0
Fordraiders
Asked:
Fordraiders
  • 4
  • 3
1 Solution
 
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
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now