Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004

    Unanswered: Refreshing Subforms and Other Matters

    Here's what I'm trying to do.

    I have a main form with a command button that I've labeled "import". The user fills in fields on the main form and clicks the import button. When the button is clicked the user can choose a text file and the code I've written reads in the text file and the manually entered data from the main form and puts both into a table in the database. This table feeds the subform within this main form. All of this seems to work fine so far.

    What I would like to add is some code or macros that will refresh and sort the data in the subform so the user can see what they've imported after it's been added to the table/subform.

    Any ideas?

  2. #2
    Join Date
    Nov 2004

    refresh form

    You should be able to simply add the following code to the end of your Import button click event code:

    Forms!<main form name>!<subform name>.requery

Posting Permissions

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