Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    May 2002
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combo Box (2000)

    I would like to create a combo box which will allow one to select a record or, if the record is not present, add the record to the database.

    The situation:

    Combo box needs to be added to form below
    Form based on 2 tables and one qry
    Qry provides donor demographics
    Operator would select donor demographics record based on 'last name' selected in the combo box
    If the operator does not see the donor's name (ie donor is new), then the operator would add the new donor demographics

    What is the best way to do this?

    Thanks,

  2. #2
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo Box (2000)

    Hi Grantjl

    Hate to do this to you on a holiday weekend.

    Try www.RogersAccessLibrary.com, see NotInList.mdb

    First time I went to this site, I od'ed 72 hours retooling my apps with these goodies.

    HTH John

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Combo Box (2000)

    It depends. Are you using ADO or DAO in your code? If you're using DAO, lookup up Recordsetclone Property Example in on-line help. If you're using ADO, look up Recordset Property and check out the example code. In both cases, the second part of the example article shows you how to use the property to find a matching record in the form's recordset. If you don't find a match, that's when you add a new record.
    Charlotte

  4. #4
    New Lounger
    Join Date
    May 2002
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo Box (2000)

    I'm just starting out, so I'm not coding at this point. Is there a simpler way to do this?

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Combo Box (2000)

    It's possible to make simple databases in Access without programming. But when you are going to create a realistic application, you can't avoid coding in VBA. There is no way to get a combo box to look up a record or add a new item without programming.

Posting Permissions

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