Comboboxes to populate from table

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

Guest

Hey all. I just wrote a new DB for my company to replace a dinosaur. We
just upgraded from 97 to 2003 and rather than convert the hand-me-down,
bloated one we were using, I wrote a new streamlined one based on what we
really needed. But.... I needed the info from the tables to keep the
records from the past several years for continuity. Needless to say, it did
not transfer without a fight! I am really happy except for one problem: It
refuses to fill two comboboxes with previous data. The cbo's are disposition
codes, which then in turn autofill two more fields, username and date().
There are 1748 records, so reentering them is out of the question. I tried
several ideas but to no avail. Can someone tell me what I did wrong? The
data is in the table and the field is named the same. I can enter new data
just fine. tia

Bryan
 
How are you tring to populate the combo box?

set it up in designe view from a query and it should work. As far as setting
auto fill create a macro and place it in the after update event of the box.
 
Hello Darrin,
I guess I'm not being clear! I am trying to repopulate the boxes with
existing data. Even though the data is in the table, (imported from old DB,)
it does not populate the cbo in the older records. If I enter the data in
fresh, it stays in the box, (obviously from the table,) the next time I open
that record. If I create a text box, using DispoCode as its source, the old
ones show up. I need to get them to show up in my cbo somehow. BTW, I am
already using code to autofill and basing my form on a query or the table
changes nothing.

Bryan
 
I figured it out. I am pulling the cbo dropdown info from a table. This
table has 2 columns, both of which show when dropped down; A 2 letter code
and a brief description. I had the bound column set on 0 like it should have
been, but when I set it to 1 it worked fine. Not sure why that is. But it
works with fresh data and the stored data now fills no matter which record I
open.
 
Back
Top