Modify MS Access database form to prompt user if record is missing to create a new record.

[I'm a tomato]

I've created a small client contact database that works fine. It has 3 tables -contact, organisation, activity.



When I add a new activity, I want the form to search to check if the contact exists. If it doesn't exist, the user should be prompted to create the contact.

You also need to provide a descriptor of what you did, so that I can modify it if necessary. Non VBA options are preferred if possible.

[June7]

Requires code (macro or VBA). I use only VBA.

One approach is to use a combobox to select contact. Set LimitToList to Yes then use NotInList event to allow creating new contact 'on-the-fly'. Review http://www.fontstuff.com/access/acctut20.htm

[aytee111]

When a new activity is entered, the first thing the user should select is the contact - usually a combobox. You can set this to restrict only valid entries, with a "new" button if the user wishes to create one on the fly, or you can have a NotInList event which will add the contact to the table.