Results 1 to 2 of 2
  1. #1
    Join Date
    May 2010

    Unanswered: Running Update Query From Form

    Ive designed a Form with Sub Form. On changing to a different record, Id like to run an update query that updates a field in the sub forms table with data from my main form.

    On close Id like to run an append query with the data just updated.

  2. #2
    Join Date
    Dec 2004
    Madison, WI
    Instead of running a query, to update a field on the subform, why not just update the field on the subform directly.

    Forms!MyMainFormName!MySubFormName!MyFieldName = Forms!MyMainFormName!SomeFieldName.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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