Solved

Combo box not showing the new record

Posted on 2011-09-23
2
325 Views
Last Modified: 2012-05-12
Hi All,
I have a combo box on to select the employees and when I add a new employee on my Employees table combo box is not showing the new record. Thanks in advance.
0
Comment
Question by:Sheogorath
2 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 125 total points
ID: 36589918
As I stated here you have to verify/fix the design and relationships of these tables *First*:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27320783.html

Besides, this is basically the same question... and basically just as irrelevant because the design of the tables may not be correct.

Again, the forms will never work if the design of the tables is not correct.
Verify the design and relationships of the tables first before ever worrying about or creating any forms.
This is database basics...


Can we get the first issue resolved *first* then you can post follow up questions...?

JeffCoachman
0
 
LVL 26

Assisted Solution

by:Nick67
Nick67 earned 125 total points
ID: 36590641
I'll second @boag2000 on that.
Data design is THE fundamental skill needed when you start working with MS Access.
Work your way through the tutorial here
http://www.phlonx.com/resources/nf3/

You have to have a correctly normalized and related set of tables before working on forms or reports.
Otherwise you are wasting your time.
Trust me.
Doing the tutorial will be some of the best time you'll spend in regard to databases.
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question