Search results for query: *

I have a cbo which is (and should be) mostly empty. However, when I click on it (but before typing anyting) I would like it to be populated with a rowsource. Once I start typing, it will wait until three letters are typed in before populating it with a new row source. The latter part I have...

Super! First when I tried it I got an error message "Run-time error '94': Invalid use of Null" and when I held the cursor over (me.Comboname.Value, me.Comboname) it displays "me.Comboname.Value=Null I then changed "call reloadcbo(me.comboname.value, me.comboname" to "call...

I have a piece of code (a function) that is used in many of the forms in my Access 2007 db. The code contains me. -references, and as I have understood it, me. does not work in modules. Is there some other reference that can be used instead? Example of the code: 'Makes company name and...

The reason I had to do something about my comboboxes is that I e.g. had a form with 3 comboboxes, each including fields concatenated from up to three different tables with each 40'-70' records. As the form was continuous 16 records showed up on the screen a time and the form became very slow...

Wonderful, it works like a charm! I chose to use the first alternative as I have a huge number of records so the field lstrange would become too long. I put the code in a module and calls it from the form. For form current I chose to insert the result of the sub directly instead of going through...

Super, many thanks!

Thanks MajP for helping out on this! However, it still does not seem to work. I still get no values in the dropdown-box. Also, when adding the code to shop the drop down list automatically I get the following error message wen switching to a new record (but not when adding a new record)...

I have a number of comboboxes in my forms linking to a table with ~40.000 records. As this tends to make the loading of the forms rather slow I tried Allen Brownes approach where the rowsource only loads after the first three letters have been typed into the box, but cannot get it to work. I...