Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004

    Exclamation Unanswered: Update Current Record

    My Query is updating the entire table. I would like it to update the current record [CQI#] on the form [frmCQIsearch]:

    DoCmd.RunSQL "UPDATE tblCQIdata SET [DiffDateClosedCust] = DateDiff('d',[Date],[Date Closed-Customer]), [DiffClosedCustClosed] = DateDiff('d',[Date Closed-Customer],[Date Closed])WHERE [CQI#] = " & Me![CQI#].Value& " "
    Any thoughts...HELP!
    Last edited by Frankenstein; 05-28-04 at 16:13. Reason: Incorrect syntax

  2. #2
    Join Date
    May 2004
    You might need to define the problem more precisely to get a better answer.

    My guess is that you are getting messages about the record being changed since you are changing the underlying record in the table but the form has no idea that *you* are doing it, instead of some other person in a multi-user database. If the form controls are bound then you need to change the values on the form, then save the form (RunCommand SaveRecord) in order to save the values to the bound record. If you want to do it the other way around you need a Refresh or a Requery so that the form will display the new data.

  3. #3
    Join Date
    Aug 2004
    I have a similar problem (I think). I have a form that filters from another form i.e . job title to job title. The problem is when the new job title is entered the main form is not updated.

    How does the Requery work?

Posting Permissions

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