Unanswered: Requery'ing a subform inside a subform from another form ??
Hi and thanx for reading my post..
Well.. generally i want to do a :
but the problem is that i got this "frmMAIN" which has "tabsubPerson" as a subform, and in the "tabsubPerson" i got "subqryPersonVehicle" as a subform too.. All this should be done from the "_frmPerson-Vehicle" form.
So... i need to refresh the "subqrypersonVehicle" with the correct syntax of .Requery.
Well.. it went through, but didn't .requery
Tried running the .Refresh after this, but that object wasn't supported for the method (??)...
AH.. btw : i put the code in "Form Open". Should i have put it elsewhere ?
Anyway.. it seems i miiight need to create something more "global", because this database is kind of a "datadump" for all criminal investigation and there are quite many many-to-many and connection-tables. (erhm.. bad language but.. )
I'm using "Category-control" in the "tabsubPerson" subform, with a "sheet" for each relation from the current form to the others.. Like "Person-Vehichle", "Person-Crimescene", Person-Telephone" etc.etc.etc..
So therefore i might need to run a .Requery on all the "sheets/tabs". Not sure how i can do that without seriously affecting the speed of loading the forms.
If anyone got any good ideas, it's most apprectiated..