Fordraiders
asked on
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![Sa pData subform].LinkMasterFields = ""
Forms!frmMainDataEntry![Sa pData 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_MAINFOR M![WR294_G RIDVIEW subform].LinkMasterFields = "Search_Term_Holder"
Forms!COSTRECOVERY_MAINFOR M![WR294_G RIDVIEW subform].LinkChildFields = "Customer Name"
i TRIED THE TEXTBOX before update event but i keep getting an error.
When i open a bound form,
I have a subform that i'm resetting the master child source to ""
Forms!frmMainDataEntry![Sa
Forms!frmMainDataEntry![Sa
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_MAINFOR
Forms!COSTRECOVERY_MAINFOR
i TRIED THE TEXTBOX before update event but i keep getting an error.
ASKER
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
"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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
very good..razzle dazzle is my thinking also.
thanks..!!
thanks..!!
ASKER
thnx
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 :)
It struck me as a good way to get after it, but that doesn't necessarily mean it was good :)
ASKER
It was a good suggestion
Yes
Yes
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.