Combo Box not posting correctly.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was given the responsibility of maintaining a database that for the most
part functions correctly. However, the data input form has a combo box that
allows you to select a student by a name.

Here is the box's row source from the properties menu:
SELECT distinctrow [MAIN ROSTER].Name, [MAIN ROSTER].PERNR FROM [Job code
table] INNER JOIN ([MAIN ROSTER] INNER JOIN [Exam Archive File] ON [MAIN
ROSTER].PERNR = [Exam Archive File].PERNR) ON [Job code table].Code = [MAIN
ROSTER].[Job Title] WITH OWNERACCESS OPTION;

I'm a novice at database design so it looks fine to me. But there is one
problem, when I go to the table "Exam Archive File" the name field is blank.
All the other fields that get input off the form are correct except for the
Name field.

What could be the problem?
 
I was given the responsibility of maintaining a database that for the most
part functions correctly. However, the data input form has a combo box that
allows you to select a student by a name.

Here is the box's row source from the properties menu:
SELECT distinctrow [MAIN ROSTER].Name, [MAIN ROSTER].PERNR FROM [Job code
table] INNER JOIN ([MAIN ROSTER] INNER JOIN [Exam Archive File] ON [MAIN
ROSTER].PERNR = [Exam Archive File].PERNR) ON [Job code table].Code = [MAIN
ROSTER].[Job Title] WITH OWNERACCESS OPTION;

I'm a novice at database design so it looks fine to me. But there is one
problem, when I go to the table "Exam Archive File" the name field is blank.
All the other fields that get input off the form are correct except for the
Name field.

What could be the problem?
Click to expand...

Well... several possibilities. First off, Name is a reserved word (every
object in an Access database has a Name property and Access can get very
confused about whether you mean the contents of the field named Name, or the
Name of the field Name, or the Name of the table, or...)

Secondly, names *are not unique*. You might have two students named Jim Smith;
you should be storing some unique unambiguous identifier (PERNR maybe???) in
the Exam Archive File. That table should NOT contain the student's name at
all. If you're using the Lookup Wizard and putting combo boxes in tables, that
may be the source of your confusion: see
http://www.mvps.org/access/lookupfields.htm
for a critique of this misfeature.

What are the Bound Column and ColumnCount and Control Source properties of
this combo?

John W. Vinson [MVP]
 
Back
Top