Solved

Combo box not showing the new record

Posted on 2011-09-23
2
299 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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

706 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now