Results 1 to 4 of 4
  1. #1
    sdel_nevo is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2013
    Location
    Gloucester, UK
    Posts
    402

    Add and edit Information in the same form?

    Hi All



    The amount of forms in my database is getting quite large, most are very similar to existing forms

    an example would be

    "Add order" is the same as "edit Order

    both of these forms contain the same data, the "edit order" for opens up to show information based on the id that is selected.

    my question is this

    is there a way to use the same for for both entering data and to view data based on an ID being selected?

    i have inherited this order database from a previous employee and im trying to tidy up the system so my boss can move forward with development of it.

  2. #2
    rzw0wr is offline I will always be a newbie
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Indiana
    Posts
    479
    I think we could, yes.

    Can you upload your database. It would be much easier.


    Dale

  3. #3
    LillMcGill is offline Dagny fan
    Windows 8 Access 2010 64bit
    Join Date
    Oct 2010
    Location
    Southern USA
    Posts
    70
    I usually make an interface with buttons. I make two buttons for each form... one button opens the form in Edit mode, the other button opens the same form, but in Add mode.

  4. #4
    sdel_nevo is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2013
    Location
    Gloucester, UK
    Posts
    402
    Hi LillMcGill

    that's a really simple solution, many thanks

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Search table in form / edit data in form
    By Guitarzan in forum Access
    Replies: 3
    Last Post: 10-02-2012, 11:37 AM
  2. Form - CANNOT EDIT TEXTBOXES !!!
    By dbalilti in forum Access
    Replies: 5
    Last Post: 07-05-2012, 12:15 PM
  3. Replies: 1
    Last Post: 12-04-2011, 09:11 PM
  4. How to edit data in a form
    By x3ldonx in forum Forms
    Replies: 2
    Last Post: 10-11-2010, 01:20 AM
  5. Cannot not edit form
    By stingray_69 in forum Forms
    Replies: 3
    Last Post: 03-18-2010, 10:49 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums