Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2013
    Posts
    11
    Thanks
    1
    Thanked 0 Times in 0 Posts

    How to refresh the subform?

    Hello,

    I have created a form and a subform from a table.

    Initially I created a table with 11 rows. After completion of my project I added an extra of 480 rows to the main table. But the newly added rows are not coming in my subform.

    Attached is my project. Could you kindly have a look into it.

    Main : Main table (It consists of around 491 rows)
    MForm : Main Form (It shows of only 11 records which I was 1st created)

    How to refresh my subform inorder to display all the rows.

    Could you kindly help me out
    Attached Files Attached Files

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    You could create the sQuery on the fly with the parameters that have been entered.

  3. The Following User Says Thank You to patt For This Useful Post:

    WhoAmI (2013-09-30)

  4. #3
    New Lounger
    Join Date
    Sep 2013
    Posts
    11
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Hello Patt,

    Thanks for your reply.

    Am Novice to MS Access.

    Could you kindly let me know how to create the SQuery on the fly with the parameters please.

Posting Permissions

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