Results 1 to 2 of 2
  1. #1
    behnam is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2014

    How to find record with certain field, and use the record to autopulate other fields.

    Hi all,

    In my form i have a field called JNumber in the table AccInfo. Once the user enters the JNumber I want to find the record in that table that has the according JNumber and autopopulate the other fields in the form (FName,LName) based on the FName and LName in that record. Can someone help me please.


  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Ottawa, Ontario, Canada; West Palm Beach FL
    Is your form bound?
    Have you considered a pop-up form? Then using the result of user input use the OpenArgs to open the form to the specific record.
    Do users really understand JNumbers more than LastName, FirstName?
    You may get some other ideas for dynamic queries and forms/reports from here.

    Good luck

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

Similar Threads

  1. Replies: 1
    Last Post: 06-06-2014, 06:32 AM
  2. Replies: 6
    Last Post: 06-03-2014, 06:23 AM
  3. Replies: 1
    Last Post: 05-26-2014, 12:39 PM
  4. Replies: 4
    Last Post: 04-01-2014, 02:33 PM
  5. Replies: 8
    Last Post: 05-05-2012, 02:01 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