Creating a Form from a Table 2003

  • Thread starter Thread starter ChuckL
  • Start date Start date
C

ChuckL

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?
 
ChuckL,
realized that I had left a couple of options out of one of the drop
down menus...
Click to expand...
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."
 
Make your drop down items a table in its own right rather than typed directly
in the list.
 
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?
Click to expand...

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.
 
Back
Top