Hello everybody.
I have a database with a bunch of company names with their contact names, adresses etc. linked to a subform with details about correspondence made with each company.
I was hoping to add some sort of code that searches automatically for a matching record based on what you start typing and this would happen where the company name is displayed now. I guess it would have to be a loop of somekind that looks for similar characters, character by character.
This way it would save time trying to find out whether a specific company had already been entered into the database or not. I do not have very much VBA experience at all.
One other question I had has to do with the subform. Everything works fine, however, my subform displays differently than when in design mode - it displays as a table rather than a form, which is quite ugly and doesn't allow for larger inputs to be read. Does anybody know how to change that around? Or is it even possible to have a subform display content in such a manner?
Thank you very much in advance!
I have a database with a bunch of company names with their contact names, adresses etc. linked to a subform with details about correspondence made with each company.
I was hoping to add some sort of code that searches automatically for a matching record based on what you start typing and this would happen where the company name is displayed now. I guess it would have to be a loop of somekind that looks for similar characters, character by character.
This way it would save time trying to find out whether a specific company had already been entered into the database or not. I do not have very much VBA experience at all.
One other question I had has to do with the subform. Everything works fine, however, my subform displays differently than when in design mode - it displays as a table rather than a form, which is quite ugly and doesn't allow for larger inputs to be read. Does anybody know how to change that around? Or is it even possible to have a subform display content in such a manner?
Thank you very much in advance!
