Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
  1. #16
    xwnoob is offline Advanced Beginner
    Windows Vista Access 2000
    Join Date
    Nov 2011
    Posts
    76
    Quote Originally Posted by pdebaets View Post
    You could use one form to do both editing and data entry. Ex.:

    stDocName = "frmBorrower"
    DoCmd.OpenForm stDocName


    with forms!frmBorrower
    .DataEntry = True 'Sets the form in data entry mode for adding
    end with

    or

    stDocName = "frmBorrower"
    DoCmd.OpenForm stDocName
    with forms!frmBorrower
    .DataEntry = False 'Sets the form in edit mode
    end with
    And where would you put this code SOrry but my programming skills are still below average. Actually in this case im letting users edit the records not add them because my menu has a button which goes to the same form in add mode

  2. #17
    pdebaets is offline Competent Performer
    Windows Vista Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Los Angeles
    Posts
    235
    This part is going to be a problem: "[tblBorrowerDetails.BorrowerTitle]="

    It should be "[tblBorrowerDetails].[BorrowerTitle]="

    Please review my comments above on this issue.

    I'm not sure what you are trying to do with this form. Are you trying to use it to add records or edit records? Why is it named "Add..."?

  3. #18
    xwnoob is offline Advanced Beginner
    Windows Vista Access 2000
    Join Date
    Nov 2011
    Posts
    76
    Quote Originally Posted by pdebaets View Post
    This part is going to be a problem: "[tblBorrowerDetails.BorrowerTitle]="

    It should be "[tblBorrowerDetails].[BorrowerTitle]="

    Please review my comments above on this issue.

    I'm not sure what you are trying to do with this form. Are you trying to use it to add records or edit records? Why is it named "Add..."?
    Ok ill change it but Can you explain why is it going to be a problem? I guess not using the auto-numbered field worked....

    ACtually its both add and edit but i named it add anyway. My database has a menu that lets users choose to add a record and another button to edit the record later

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Two forms opening the same form
    By MikeMairangi in forum Forms
    Replies: 5
    Last Post: 08-31-2011, 01:55 PM
  2. opening forms extra records
    By Lupson2011 in forum Access
    Replies: 2
    Last Post: 08-31-2011, 10:26 AM
  3. Forms opening on new record entry
    By daddylongtoe in forum Forms
    Replies: 4
    Last Post: 06-28-2010, 04:15 AM
  4. prevent editing current entries in forms
    By Chazcoral in forum Forms
    Replies: 1
    Last Post: 05-20-2010, 06:49 PM
  5. Editing forms suddenly gone wrong
    By twinfair in forum Forms
    Replies: 3
    Last Post: 02-19-2010, 07:48 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