Results 1 to 2 of 2

Thread: Force an update of record in a subform in Access 2000

  1. Sep 9th, 2003, 01:53 PM #1
    M Owen
    M Owen is offline

    Thread Starter
    Lively Member
    Join Date
    Jun 2003
    Posts
    114

    Force an update of record in a subform in Access 2000

    Hi all.

    I have an embedded form within my main form (subform). This subform is not linked to the main form either ... I do a query action to populate the subform with data that I act on by changing the 1st column to a different value using the column's .Value method. What I want to do is to force the write to the underlying table ... Any ideas on how to do this? (It probably is simple ... ) Thanks!

    - Mike
    Reply With Quote Reply With Quote
  2. Sep 22nd, 2003, 07:47 PM #2
    -=XQ=-
    -=XQ=- is offline
    Hyperactive Member -=XQ=-'s Avatar
    Join Date
    Mar 2002
    Location
    Liverpool, England, UK
    Posts
    278
    You should use the Refresh method to immediately update an underlying table with data from the form.

    The requery method would be used to lose any changes in the form and repopulate the fields with data from the table.

    Hope that helps.
    See ya later,

    -=XQ=-

    "Reality is merely an illusion, albeit a very persistent one. "
    - Albert Einstein (1879-1955)
    This is the coolest site ever!!!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width