Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2004

    Unanswered: record submit...

    pushing my luck with two questions in one day....

    i've built a form that allows users to add/edit records in a table and i don't want the changes to be "live". I'd rather they have a button to submit the edits once they've been completed. any help is already appreciated.

  2. #2
    Join Date
    Sep 2003
    don't use access....

  3. #3
    Join Date
    Sep 2004
    Dallas, TX
    I have same problem too

  4. #4
    Join Date
    Sep 2004
    Reston, VA
    You may have to make a custom form that
    1. displays the records in a listbox with the table as a record source
    2. populates unbound textboxes / combo boxes with the fields you want to edit when a record is selected in the listbox
    3. runs an action query in an ADO Command to update or append to the underlying table when a button is clicked
    4. and requeries the listbox immediately after to make it look like the listbox itself was edited.

    I do that a lot for the forms that I create. You have to spend more time designing it, but it gives you basically unlimited control over what the user can do and see. There may be a simple way to do it with Transactions on a ADO Connection object, but I tried doing that once and basically gave up...the other way is more customizable.

Posting Permissions

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