If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Adding a Combo Box
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 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 - |
Thread Tools | |
Display Modes | |
|
|