Results 1 to 2 of 2

Thread: Form REQUERY

  1. #1
    Join Date
    Aug 2003
    Posts
    1

    Unanswered: Form REQUERY

    Hi,

    i have a small form in my principal form. The link between the both form is an invoice number. When i update the invoice number (in VBA code), i do a Requery on my small form, to show the good information with the new invoice number, but that don't work.

    Form_sousFrmCommande.Requery

    I don't know why that don't work, but i really need that !

    Please help me quickly !

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    is your code in the principal form module??

    assumption:
    the principal from is named frmPrincipal

    in design view of frmPrincipal with the properties window open on the Others tab, click on formPrincipal NOT in the subform area and then click again ONCE in the subform area: properties/other/name tells you what access thinks the subform is called (which may not be what you think it should be called!).
    assume that this prop/other/name = Subform1

    now your requery line should read:
    forms!frmPrincipal!Subform1.requery
    (substitute real names of course)

    izy

Posting Permissions

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