Adding a Combo Box

Please bear with me because I'm very inexperienced with Microsoft
Access. I have a simple existing database that consists of a form and
a table of half a dozen fields. There are a few thousand records in
the database. I would like to add a new field to the table, and then
create a combo box in the form to use to enter information into the
new field.

Can someone give me a quick overview of the process to add a new field
to a table with a combo box in the form to control the field? I'm not
looking for anything too detailed, just some general information to
get me going in the right direction.

I don't think it will matter, but in case it does, the table is
linked. (I.e, basically the form is in one database, and the table in
another...and the table is linked to the form.)

I'm using Access 2003.

Thank you!

Randy Seys
Mankato, MN

You will need to go into the table in the other database and go to design
view. After the list of fields, add your field and set the datatype you
desire (text, date, etc.) Now go back to the other database and click on
file/get external data/ link tables and re-link it. After relinking it will
pick up the new field. Now add your combo to your form and allow the wizard
to select that filed for you. Or you could go to design view of the form,
click on field list, and insert the field.

"Randy" wrote:

Please bear with me because I'm very inexperienced with Microsoft
Access. I have a simple existing database that consists of a form and
a table of half a dozen fields. There are a few thousand records in
the database. I would like to add a new field to the table, and then
create a combo box in the form to use to enter information into the
new field.

Can someone give me a quick overview of the process to add a new field
to a table with a combo box in the form to control the field? I'm not
looking for anything too detailed, just some general information to
get me going in the right direction.

I don't think it will matter, but in case it does, the table is
linked. (I.e, basically the form is in one database, and the table in
another...and the table is linked to the form.)

I'm using Access 2003.

Thank you!

Randy Seys
Mankato, MN

Correct with one exception.
The OP does not need to use file, get external data, rather go to the linked
table manager (Tools, Database Utilities, Linked Table Manager), select the
modified table, and relink.
--
Dave Hargis, Microsoft Access MVP


"Golfinray" wrote:

You will need to go into the table in the other database and go to design
view. After the list of fields, add your field and set the datatype you
desire (text, date, etc.) Now go back to the other database and click on
file/get external data/ link tables and re-link it. After relinking it will
pick up the new field. Now add your combo to your form and allow the wizard
to select that filed for you. Or you could go to design view of the form,
click on field list, and insert the field.

"Randy" wrote:

Please bear with me because I'm very inexperienced with Microsoft
Access. I have a simple existing database that consists of a form and
a table of half a dozen fields. There are a few thousand records in
the database. I would like to add a new field to the table, and then
create a combo box in the form to use to enter information into the
new field.

Can someone give me a quick overview of the process to add a new field
to a table with a combo box in the form to control the field? I'm not
looking for anything too detailed, just some general information to
get me going in the right direction.

I don't think it will matter, but in case it does, the table is
linked. (I.e, basically the form is in one database, and the table in
another...and the table is linked to the form.)

I'm using Access 2003.

Thank you!

Randy Seys
Mankato, MN