Forms & Editing Lookup Columns

[Ruth]

I have a form on which I use to input information. It is based on a query
that is based on a table.

One of the fields in the table is a lookup field based on items that I have
typed in (as opposed to another record source). I wanted to add an item to
the lookup field so I went into Table/Design View and added the new item to
the list in the row source box in the lower part of the screen. It has saved
the new item, but when I go into the form I cannot see it in my drop down
list.

How do I get the form to recognise that I have added a new item?

 

[Dale Fye]

Ruth,

I stongly recommend against entering values in "lookup fields". Create a
new table with an ID value, the text you want to display, and a Sort_Order
column (you only need the sort order if you want to be able to change it or
sort by something other than an alphabetic list or the ID sequence).

Now, use the ID value to store in other tables that relate to this data, and
use this table, or a query created from it as the source for combo boxes.

HTH
Dale

 

[Ruth]

Thank-you - I knew there must be a simple solution!