retrieval of record using maskedit box to textboxes from ms access table

Hello guys!!
I need your help. I am working on a project right now and I plan to use the maskedit box control where the user would enter the ID Number and in the textboxes the lastname,firstname and middle initial would automatically appear once the cursor is transferred to another textbox. I have the difficulty of creating the codes for this. My first option was to use the dropdown combo box but then I dont think it fit for my intended feature of the project. I am using vb 6.0 and my backend is ms acess 2003. Hope to hear from you soon guys. Thanks!!

Welcome to VBForums :wave:

For a general idea on how to work with databases from VB, see the ADO Tutorial link in my signature - it includes code for connecting to the database, displaying the data, and a link to an article that includes searching (which is what you want for the maskedit/combo).

I would personally go for the combo option (as you can set it to load the existing data when the form loads, and it has autocomplete features built in), with 'search' on _LostFocus. I don't know why you think it isn't apt for you, but if you give more details I'm sure we could come up with a decent workaround to allow the features of both.

Thank you so much si_the_geek! I wont forget this.