Update value in tbl source for combo box

[Jen]

Using Access 2003.
I have a Form (frmRequests) and a SubForm(frmRequests_sub) for capturing
report requests.
The frmRequests_sub is based on the table "tblRequests" where all data
entered in the subform is stored.
Within the subform, I have a few combo boxes where the row sources are other
tables (with values).
I want these tables (supplying the combo boxes data) to be updated if the
end user cannot find what they are looking for in the existing list.
Example: In the "Requestor" field/combo box where row source is
tblRequestor, if "Jane Doe" is not is the existing list, I want the user to
be able to type "Jane Doe" and then "Jane Doe" would be added to tblRequestor
as a future value.

I have been doing alot of searches and finding similar functions but nothing
to meet my needs exactly.
I am also seeing issues where once the value is entered, the combo box is
not updated; requeries need to happen.
For this scenario, will this still need to happen?

Thanks.
Jen

 

[Maurice]

Jen,

Try searching for a post with "Not in list" in the title. My guess is that
this option should do the trick for what you want.