Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    42

    Unanswered: Update record on form

    I have a form with query as a record source. Currently the user has to move to the next record before the table will be updated with the values assigned by the combo box selection. When the user chooses a selection from the combo box I want the record to update the table(combo box on change event?) without the user having to move to the next record(using the record navigation buttons). so basically if they are on the last record in that form the changes from the combo box will not get saved unless the table is updated by moving to the previous record where as I want the table updated once a selection is made from the combo box. Is this possible?

    Thanks in advance. Any ideas?

  2. #2
    Join Date
    Sep 2003
    Location
    T.O.
    Posts
    326
    Function SaveCurrentRecord()

    On Error GoTo Err_SaveCurrentRecord

    DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70


    Exit_SaveCurrentRecord:

    Exit Function

    Err_SaveCurrentRecord:

    MsgBox "Err No: " & Err.Number & Chr(13) & "Err Desc: " & Err.Description & Chr(13) & "Source: " & Err.Source

    Resume Exit_SaveCurrentRecord


    End Function
    All code ADO/ADOX unless otherwise specified.
    Mike.

  3. #3
    Join Date
    Aug 2003
    Posts
    42
    got it...THANKS!

Posting Permissions

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