If not in list, then add the update then select

[PLiNk]

Hello wonderful forum!

To be brief, I am tired of the
"Item not in list" error message.

I am creating a database for notes, and
somebody is gong to sit there all day typing
in the title, the name of the composer and the arranger and the author of the text, as well as the publisher.
What I need is a piece of code that does the following to 4 different fields in sequence:

When the input in the field is done and I press enter I would like the program to
check if the record exists, if it does: ok; if it doesn't add it to the list. Then select it.

I have tried this before but the code stopped working and I never figured out why and I never got i to work again.
I'm not too good at coding you see.

Jens Tandstad

 

[BNPMike]

You'd normally do this a different way. You'd generate a form that allows you to put in the four key fields. Then it will either display the existing data to edit or create a new empty record for you. This is a standard Access process, and should be in any Access manual you are using.