Create new record via msgBox option if Search function return NULL/zero value

Hi all,

Would appreciate your help!

I have a Search function on my UserForm that lists all possible matches/suggestions in a ListBox. When I double click the desired record in the ListBox, it populates my UserForm with that specific DB record.

This is where I need your help! a)When there is NO possible match, i.e. the ListBox is empty, I would like to create a new record via a msgBox yes/no option. b)Have the option to create a new record, without using the search, or when there are possible matches.

I was thinking in the lines of:

Please Login or Register  to view this content.

This is the code for my search textBox:

Please Login or Register  to view this content.

This is the code that allows me to select a record from my ListBox:

Please Login or Register  to view this content.

I am not to sure how to integrate the code, but THINK it should most probably be part of the Search textBox code....

Thanks a lot!

Hi all, any help?