Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jan 2003
    Dayton, Ohio, USA
    Thanked 0 Times in 0 Posts

    Automatic Filling of fields (Access 2000)

    I am looking for method to takes fields from one database and appending to another database. Ex. database #1 has name, address, city, state, zip code. In database# 2 I have a combo box for name, and regular fields for address,city,state,zipcode. I want to use the search for the name in the name combo box and have all other information automatically added that goes along with the name in the rest of the fields and save it in number two database. I did it in the old database by appending and editing the new record.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Evergreen, CO, USA
    Thanked 65 Times in 64 Posts

    Re: Automatic Filling of fields (Access 2000)

    One approach is to simply link to the tables in database #1 from database #2. Make the linked table the data source for the form, and place a button on the form that executes a query which appends records to the new table in database #2 from the record currently displayed in the form. There are some issues to think about in terms of creating duplicates - so you may need to have a primary key to block that kind of thing. Otherwise it is a fairly simple approach that only involves code you can generate using the command button wizard. The only trick is setting up the append query so that the criteria references a primary key displayed on the form. Post back if you need further explanation.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts