Sub-form lookup

[rguy84]

I have been making a call log. Due to the nature of it we have multiple entries per person usually. So typing a person's contact details 5 times gets annoying.

I was thinking of having a button that brings up another form that has every name (first last) of everybody who is currently added. I could click their name, and another button. The button would populate the main form and close the small form.

Ths is somewhat easy to do in access,. but not sure how to start in excel.

 

[Norie]

Ryan

Sorry you've lost me now, I thought you understood that the index was zero-based?

Perhaps you are thinking of arrays and Option Base 1?

 

[rguy84]

ah yes precisely.