Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Oslo
    Posts
    45

    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 :

    Forms![frmMAIN]![Subformname].Requery

    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.

    Anyone can help me out with this ?

    Best regards
    Terje.
    Best regards
    Mirador

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Basically drill down thru the subform controlname ... Ex:

    Forms![MainFormName]![SubFormControlName].Form.[SubFormControlName].Requery

  3. #3
    Join Date
    Jan 2004
    Location
    Oslo
    Posts
    45

    Question Code went through, but didn't requery.

    Thanx for your reply

    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..

    */Terje*/
    Best regards
    Mirador

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •