Corrections not showing up in form drop-down list

  • Thread starter Thread starter snash11
  • Start date Start date
S

snash11

Hi all,

I am fairly new to Access and am trying to make a grade book for a
small school. I have made tables for teachers, students, subjects, and
grades. When I made the subjects table I included a combo box in the
subject field and listed all the subjects. I then created a form to
view the data, and wouldn't you know it-one subject was missing and one
was misspelled.

I went back to the subject table and made the changes, however when I
opened the form and looked in the drop-down list none of the changes
were reflected.

Can someone point me in the right direction to fix this form or do I
have to delete it and make a new one?

Thanks for your help
 
Thanks for your reply,
Yes, I did close the form, and when that didn't work I even closed out
of Access and then re-started it. Still there were no changes.
Could I have messed up some setting somewhere in the Lookup tab of the
table?
Steve
 
Hi all,

I am fairly new to Access and am trying to make a grade book for a
small school. I have made tables for teachers, students, subjects, and
grades. When I made the subjects table I included a combo box in the
subject field and listed all the subjects. I then created a form to
view the data, and wouldn't you know it-one subject was missing and one
was misspelled.

I went back to the subject table and made the changes, however when I
opened the form and looked in the drop-down list none of the changes
were reflected.
Click to expand...

That's because you have TWO DIFFERENT combo boxes: one of them in the
table; and a *different* combo box on the form. Each combo box has its
own independent list of values.

Most of us discourage the use of Table Lookup fields, for this exact
reason!

I'd strongly suggest creating a Table of subjects, and using this
Table (or an alphabetized query based on the table) as the Row Source
of combo boxes on your forms, rather than using the List of Values;
this will let you update the subject name in the Subjects table and
have it reflected in all your combo boxes, without needing to revise
them.

John W. Vinson[MVP]
 
Hi, sorry it took so long to get back to you. I've been sick and just
now felt able enough to get moving!
If I understand you I need to use my Subject table as the source for
the forms? and use ROW SOURCE instead of LIST OF VALUES? is that
correct? I'm sorry if I appear stupid, but I'm trying to learn. Again
thanks for your help!! Steve
 
Hi, sorry it took so long to get back to you. I've been sick and just
now felt able enough to get moving!
If I understand you I need to use my Subject table as the source for
the forms? and use ROW SOURCE instead of LIST OF VALUES? is that
correct? I'm sorry if I appear stupid, but I'm trying to learn. Again
thanks for your help!! Steve
Click to expand...

Well... you use whatever you need to use.

A Form has a "Recordsource" property. This is usually a query on one
(rarely two or more) tables, occasionally just the name of a table if
you don't care about the order in which the records are presented. You
very well might want a small maintenance Form based on the Subjects
table, just for the purpose of adding new subjects, deleteing them,
editing the spelling, and so on.

Your main classes form would have a Combo Box for entering the
subject. While you *COULD* use a List of Values for this purpose,
that's inconvenient, since you must open the Form in design view
(maybe several forms!!), and change the actual properties of the combo
box when you make a change to any subject. It's much simpler to use a
Query based on the Subjects table as the basis of a query to sort the
subjects alphabetically (or into some other suitable order), and use
this Query as the RowSource of the combo box. The RowSourceType
property would be "Table/Query".


John W. Vinson[MVP]
 
OK, I'll try and make the corrections. I'll keep you informed of the
outcome!
Thanks again for your help.
Steve
 
Back
Top