Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Feb 2002
    Location
    Netherlands
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    keeping form up-to-date (2000)

    Form1 based on Query1 on Table1. Query1 keeps all fields of Table1.
    Button: make new record. This button opens dialog-Form2 Query2 on the same Table1. Query2 keeps all obligated fields of Table1.
    After entering these obligated fields, dialogFOrm2 closes.

    Problem: I can
    Attached Files Attached Files

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: keeping form up-to-date (2000)

    In the on close event of form2, enter
    <pre>Private Sub Form_Close()
    Forms.Form1.Requery
    End Sub</pre>

    Francois

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: keeping form up-to-date (2000)

    Addendum to my previous post.
    If you have combo boxes on you form add the line
    <pre>Forms.Form1.cmbMyCombo.Requery</pre>

    to requery them to.
    Francois

  4. #4
    New Lounger
    Join Date
    Feb 2002
    Location
    Netherlands
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: keeping form up-to-date (2000)

    oops. you're right.

  5. #5
    New Lounger
    Join Date
    Feb 2002
    Location
    Netherlands
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: keeping form up-to-date (2000)

    right again. and is the case indeed in my real db!

    thanks again!

Posting Permissions

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