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
|
|||
|
|||
Creating a Form from a Table 2003
I am new to Access. I created a table with the appropriate fields which
include a couple of drop down menus. I then created a form for data inupt. I realized that I had left a couple of options out of one of the drop down menus so i went back to the table and added the options. But those options do not appear in the form...? How do I get the form to update as I revise the table? |
#2
|
|||
|
|||
Creating a Form from a Table 2003
ChuckL,
realized that I had left a couple of options out of one of the drop down menus... By "drop down menu", I assume you mean a combobox. Not sure what you mean by adding "options" to a combobox in your table I'll assume your adding a new field to your original table... Every form has either a Table, or a Query behind them to provide the records (recordset) that the form will display. Table Record Source... If you add a field to a table, and your form uses that TABLE as the RecordSource for the form, it will automatically appear on your Field List, and be available to place on the form. Query Record Source... If you use a query (usually) as a Record Source for the from, you'll need to make sure that the new field in your table is included in the forms's Record Source SQL string (ot the query design grid). Only then will it appear on the form's Field List... and be available for placement on the form. -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "ChuckL" wrote in message ... I am new to Access. I created a table with the appropriate fields which include a couple of drop down menus. I then created a form for data inupt. I realized that I had left a couple of options out of one of the drop down menus so i went back to the table and added the options. But those options do not appear in the form...? How do I get the form to update as I revise the table? |
#3
|
|||
|
|||
Creating a Form from a Table 2003
Make your drop down items a table in its own right rather than typed directly
in the list. "ChuckL" wrote: I am new to Access. I created a table with the appropriate fields which include a couple of drop down menus. I then created a form for data inupt. I realized that I had left a couple of options out of one of the drop down menus so i went back to the table and added the options. But those options do not appear in the form...? How do I get the form to update as I revise the table? |
#4
|
|||
|
|||
Creating a Form from a Table 2003
On Thu, 5 Nov 2009 05:32:01 -0800, ChuckL
wrote: I am new to Access. I created a table with the appropriate fields which include a couple of drop down menus. I then created a form for data inupt. I realized that I had left a couple of options out of one of the drop down menus so i went back to the table and added the options. But those options do not appear in the form...? How do I get the form to update as I revise the table? You're another victim of the misleading, limited and inadequate "Lookup Wizard". This was a new feature in A2002 or A2003 and has caused people no end of trouble like what you're seeing: see http://www.mvps.org/access/lookupfields.htm for a critique. Fields in a table *contain data*. They do not contain dropdown boxes, or listboxes - these are display tools. As you have seen, putting a combo box in a table does not guarantee that that display tool carries over correctly to the Form! I would suggest opening the table in design view and changing the Lookup property for each of these fields from Combo Box to Textbox. This will let you see in the table what actually IS in the table (usually a numeric ID, rather than looked-up text). Create a Table for each "lookup" - the only time I'd use a list of values instead of table/query is if the list is very static and very short (e.g. Gender "M;F"). If you'll ever be editing or adding to the list, a table is much more convenient. Then use the Combo Box Wizard on the toolbar to add Combo Boxes to your form (not to your table) based on these lookup tables. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|