H
Hindsey
I have a combo box on a form that looks up addresses from a table. When an
address is typed in, my code writes the address to a file for another program
to use. If a user types in an address that is not in the combo box, I would
like the user to be prompted with two options: 1 - to add it to the table, 2
- to ignore that it's not in the combo box, and pass the entered address to
the file anyway.
I figured out how to use the "limit to list" and "not in list" options. It
actually works ok, but after I pass the manual address to the file, I still
get the error message from Access that "the text you entered isn't an item in
the list."
I can think of two solutions, but don't know how to implement.
1 - suppress that error message, and I think all will be well.
2 - use the After Update code and identify that the address that was entered
was not in the list. (However, my list is some 28,000 entries, so I'm not
sure that is the best way to do it.)
Any help would be greatly appreciated!
Andy
address is typed in, my code writes the address to a file for another program
to use. If a user types in an address that is not in the combo box, I would
like the user to be prompted with two options: 1 - to add it to the table, 2
- to ignore that it's not in the combo box, and pass the entered address to
the file anyway.
I figured out how to use the "limit to list" and "not in list" options. It
actually works ok, but after I pass the manual address to the file, I still
get the error message from Access that "the text you entered isn't an item in
the list."
I can think of two solutions, but don't know how to implement.
1 - suppress that error message, and I think all will be well.
2 - use the After Update code and identify that the address that was entered
was not in the list. (However, my list is some 28,000 entries, so I'm not
sure that is the best way to do it.)
Any help would be greatly appreciated!
Andy