Results 1 to 4 of 4
  1. #1
    Guitarzan is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2012
    Posts
    15

    Search table in form / edit data in form

    Hi all,


    I have a form called Accounts.frm that I have approximately 20 users enter data into. Someone will go in behind each user sometime in the next week or possibly a bit longer. The 2nd person needs to verify the first person:

    a. created a record for the account#
    b. entered the correct data for the account#

    I need the user to be able to search the tables in this form for a record and see if one for the Account# exists. I need the data entered for that account# to pull up in the form. Then once person 2 pulls up the account# record, they can edit the information if it is incorrect.

    I originally thought I could just have them use the record search at the bottom of the form but it seems this function only works for data you enter during the current session.

    I know this sounds easy but I'm pretty new to access and learning on the fly. I have tried Googling as well but I'm thinking there is something really easy that could allow me to do this so I figured I'd start with the experts!

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    Base your validation form on a query that is looking for a specific account number, the easiest way to do this is to create a query and put [Enter the Account Number] in the criteria of the query. Create your validation form based on that query and put a button in the form header or form footer and in the ON CLICK event of that button put in

    me.requery

    Every time they click this button they'll be asked for an account number and your form will bring up all information relating to that account.

  3. #3
    Guitarzan is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2012
    Posts
    15
    I'm officially an idiot. I couldn't use the search at the bottom simply because I had data entry mode set to "on".

    Now, the only thing I need to figure out is how to get my form to default to a new form instead of a previous record?

  4. #4
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    when you open the form docmd.gotorecord acnewrec (not 100% sure of the syntax but it's something like that)

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

Similar Threads

  1. Replies: 2
    Last Post: 02-13-2012, 02:41 PM
  2. Replies: 9
    Last Post: 02-15-2011, 03:05 PM
  3. Edit Data and Recalculate WITHIN THE FORM ONLY
    By AusStiffler in forum Forms
    Replies: 3
    Last Post: 10-19-2010, 04:32 AM
  4. How to edit data in a form
    By x3ldonx in forum Forms
    Replies: 2
    Last Post: 10-11-2010, 01:20 AM
  5. Most reliable way to edit form data in VBA...?
    By samalter in forum Programming
    Replies: 0
    Last Post: 06-23-2006, 12:39 PM

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