Find Record or Add New

[Kirsty]

Hi I have a table that is indexed on the tel# field (no
duplicates). My input form lets you fill in a tel# while
automatically filling in the number as you type, when you
press enter you get the record attached to that number.

What I need to know is when that tel# does not exist in
the table, how do I get it to let me add a new record,
and once updated, how do I get the recordset to refresh
so that it reflects this new record without having to
close the form and reopen it again?

Thanks for the help
Kirsty.

 

[Jeff Boyce]

Kirsty

You didn't indicate what kind of field you are using to enter/look for the
"tel#" value.

If you use a combo box, with LimitToList turned on, you/Access can trap a
"Not in List" situation and react, via code, by: 1) prompting to enter a
new record, 2) updating/refreshing the combo box list after adding.

Check Access HELP for Not In List. If your version of Access makes this
difficult, try checking Google.com under the msaccess group for "Not in
List".