search record in vba

[accesslover]

hello


I have this example
I want to inter user id
So, after i leave textbox access will search for this Id if it is already in the table it will bring it back to the form to view
but if there is no record with that ID it will allow me to continue adding a new user with new Id


how I can do it in vba ?????

userid.accdb

[Gicu]

Many ways to do that, here is a quick one using a bound form and a combo used for searching with code in NotInList event to add new record.

Cheers,