F
freddymon
Hi, I've got 2 tables, that provide input to a form
Table one (TitleList) contains one field (Titles) of unique titles (i.e.
Mr., Mrs., Dr.), which is a primary key. This table provides a source for a
field on the 2nd table.
The second table (NameList) contains personal information with a unique ID
number as a primary key, and a text field "Title" that is a combo box with a
row source that is a query from table 1 (SELECT TitleList.Titles FROM
TitleList).
I've set up a one-to-many relationship between TitleList.Titles and
NameList.Title.
I'm setting up a form to enter records into the "NameList" table and would
like to allow the "Titles" list inthe TitleList table to grow (based on input
in the [NameList].[Titles] combo box) as more data is input and more salutory
titles are added. I have the "Title" combo box on the form set to use the
same row source as the Title field in the table (SELECT TitleList.Titles FROM
TitleList), have the 'Limit To List" property set to "Yes", set up a macro to
open the"TitleList" table in ADD mode, and assigned it to the "NotInList"
property for the combo box.
Whenever I add an entry into the [Forms]![NameList]![Title] combo box the
macro fires as planned, but a Microsoft office Access info box, "The text you
entered isn't in an item in the list" pops up.
Is there a way to set this up so the macro will run to add an entry but the
Access Info box will not pop up?
Table one (TitleList) contains one field (Titles) of unique titles (i.e.
Mr., Mrs., Dr.), which is a primary key. This table provides a source for a
field on the 2nd table.
The second table (NameList) contains personal information with a unique ID
number as a primary key, and a text field "Title" that is a combo box with a
row source that is a query from table 1 (SELECT TitleList.Titles FROM
TitleList).
I've set up a one-to-many relationship between TitleList.Titles and
NameList.Title.
I'm setting up a form to enter records into the "NameList" table and would
like to allow the "Titles" list inthe TitleList table to grow (based on input
in the [NameList].[Titles] combo box) as more data is input and more salutory
titles are added. I have the "Title" combo box on the form set to use the
same row source as the Title field in the table (SELECT TitleList.Titles FROM
TitleList), have the 'Limit To List" property set to "Yes", set up a macro to
open the"TitleList" table in ADD mode, and assigned it to the "NotInList"
property for the combo box.
Whenever I add an entry into the [Forms]![NameList]![Title] combo box the
macro fires as planned, but a Microsoft office Access info box, "The text you
entered isn't in an item in the list" pops up.
Is there a way to set this up so the macro will run to add an entry but the
Access Info box will not pop up?