Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    18

    Question Unanswered: Union Query Question

    I have a union query which is displayed as a subform on one of my forms. I understand that a union query cannot be updated (although I am secretly hoping there is a way around that), but I want to know if it is possible to requery the union query and having the requery results displayed in the subform?

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Stick this line in wherever you want to cause your subform
    to grab new info...

    Forms![formname]![subformname].Form.Requery

    I don't know of a workaround for updating a union query,
    other than updating the base data, and rerunning the query.
    I assume that's what you're trying to do here.
    Inspiration Through Fermentation

Posting Permissions

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