Results 1 to 2 of 2
  1. #1
    kdcooper88 is offline Novice
    Windows XP Access 2010 (version 14.0)
    Join Date
    Sep 2010
    Posts
    2

    Exclamation Autofill

    I have created a form to allow customers to register at an open house at work. However I am trying to figure out a way to automatically fill certain fields if two customers from the same company come and one has already registered. For example; if john smith from company xyz came to register and bob brown from the same company had already registered, once john smith entered in xyz in the company name field it would automatically fill in the company's address, city, street, zip code, phone number, and fax number based on the information bob brown gave when he registered. Is it possible to do this without having a company list already created for it to reference? Please help and let me know if this is not clear.


    Thanks,
    Kyle

  2. #2
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    Hi,

    if John Smith registered for the company xyz the company data zre already stored in the database aren't they? As more persons from 1 company can register I presume you have two tables there with a one to many relationship. The company data would be stored in tblCompany or so, so the list already exists! In the registery form I would propose to place a combo box with the existing company data and a possiblity to enter a new company if it ain't registered yet.

    greetings
    NG

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

Similar Threads

  1. ComboBox Autofill
    By t_dot in forum Forms
    Replies: 2
    Last Post: 08-19-2010, 06:18 AM
  2. Autofill of a field based on another
    By MyWebdots in forum Forms
    Replies: 7
    Last Post: 07-12-2010, 05:00 AM
  3. date calculation then autofill?
    By nktrygg in forum Access
    Replies: 6
    Last Post: 01-19-2010, 11:04 AM
  4. Autofill with data from another form
    By jacrum in forum Forms
    Replies: 2
    Last Post: 08-11-2009, 11:17 AM
  5. Autofill form fields
    By roboticsguy1988 in forum Forms
    Replies: 1
    Last Post: 08-10-2009, 08:56 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