addition to combo box table doesn't show up in form

  • Thread starter Thread starter fveel
  • Start date Start date
F

fveel

Greetings:

I'm fairly new to Microsoft Access however have been able to
manage to accomplish creating a database with 2 tables and 1 form with
a combo box. 1 table is used as source for the combo box in the form
and the other table contains all my data (including the choices made
from the combo box). Everything seems to be working and we have been
entering data for the last couple of months aOK. Now I want to add an
entry into the table source for the combo box ... which I did. This
table now contains the addition however when I pull down the combo box
on the form the new entry isn't there ... all the previous choices are
still there but not the addition just doesn't show up.

I've been looking and poking around for the some time now and just
can't figure out what I'm missing. Can anyone point me in the right
direction to fix this?

thanks ...... flo
 
Please disregard my posting below .... I'm an idiot!!! I just
discovered what the problem
was. The pulldown combo box is rather lengthy and although the
addition to the source table was done in alphabetical order the
addition appeared all the way at the bottom of the pulldown choices as
I didn't have the query set to Ascending. I hadn't scrolled down to
the bottom of the combo box but rather was looking at it alphabetically
for the addition which is how I had added the entry to the source
table. duhhhhhhh

......flo
 
Back
Top