asked on

Add records to Access 2007 Table from within an Access 2007 form

In Access 2007 I have a form that's bound to a table, I need one field on that form to allow me to add records to the table at times, while other times I'd want to select from existing data, I tried both the Combo Box or List Box options and it seems like I'm missing something here.

SOLUTION

peter57r

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Roberto Madro R.

ASKER

I don't need to "Search" for an exisitng value, in a comprable setup I'm able to select from an existing value from the drop down list, or simply type in a new value if what I'm looking for doesn't exist, the issue here is, I tried to emulate what I've done in my test environment to that in the production environment but couldn't form some reason and that's why I got in touch with you guys.

SOLUTION

peter57r

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015

Maybe this is what you need:

Adding values to lookup tables

ASKER CERTIFIED SOLUTION

Andrew_Webster

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Roberto Madro R.

ASKER

The solution(s) worked and thanks to all 3 experts, other unrelated design issues are at play as well but I got what I need from the Exchange for now.

Many Thanks to all of you.