Re: Adding a Combo Box

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Ok, I figured it out. I needed to add the field to the form record
source. Once I did that, the field would show up.

Thank you, Golfinray, for your reply!!!

Regards,
~Randy


On Jul 17, 8:50 am, Randy <ironh...@xxxxxxxxxxxxxxx> wrote:
Hi again,

Thank you very much for your reply.  Everything seems to work fine
until I get to the point where I try to allow the wizard to select the
field.  The new field does not show up.  The new field does not show
up in the field list either.  I've re-linked the table as you
described.  I've also run the Linked Table Manager in an attempt to re-
link the table.  Lastly, I've deleted the existing link completely and
recreated the link.  Nothing seems help...the new field refuses to
show up.

Any suggestions?

Thank you!

Randy Seys
Mankato, MN

On Jul 16, 3:55 pm, Golfinray <Golfin...@xxxxxxxxxxxxxxxxxxxxxxxxx>
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- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

.

Relevant Pages

  • Re: After splitting database
    ... "Randy Harris" wrote: ... >>> the BE mdb. ... when more than one person may use the database, ... > and reason for a split database. ...
    (microsoft.public.access.gettingstarted)
  • Re: MS Works Database ~ print options ~
    ... Randy wrote: ... Today has just been awful! ... I need your help printing out a database I have created! ... I want the database to print out on 8 1/2 x 11 plain paper and show the grids. ...
    (microsoft.public.office.misc)
  • Re: Force a submit() on parent from child?
    ... database. ... Although there is no reason why it shouldn't, ... post data back to the server, and reload it, and the new data. ... Randy: hardness is relative. ...
    (comp.lang.javascript)
  • Re: ? degrees of separation
    ... I wasn't the first person to point out the limitations of ... > the database, nor the restrictive nature of the criteria. ...
    (rec.music.artists.springsteen)