Solved

resetting the master child  links in the right place

Posted on 2016-07-15
7
28 Views
Last Modified: 2016-07-15
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
Comment
Question by:fordraiders
  • 4
  • 3
7 Comments
 
LVL 26

Expert Comment

by:Nick67
ID: 41713025
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
 
LVL 3

Author Comment

by:fordraiders
ID: 41713033
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
 
LVL 26

Accepted Solution

by:
Nick67 earned 500 total points
ID: 41713050
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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 3

Author Comment

by:fordraiders
ID: 41713053
very good..razzle dazzle is my thinking also.
thanks..!!
0
 
LVL 3

Author Closing Comment

by:fordraiders
ID: 41713104
thnx
0
 
LVL 26

Expert Comment

by:Nick67
ID: 41713140
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
 
LVL 3

Author Comment

by:fordraiders
ID: 41713141
It was a good suggestion
Yes
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now