Search results

The NotInList event should handle that. If the control loses the focus and the selected value is not in the list, it should automatically call the NotInList event. If you really want to do it by writing code I guess you could check if the selected value exists in the combo box row source but...

But I want to make a disclaimer that my VBA skills are not stellar so take that advice for what its worth ;)

The problem is that you have an argument in your subroutine for NotInList (NewData As Strong, Response As Integer) so you have pass the arguments to the subroutine To call it you would have to write: Call cmbSong_NotInList (Arg1, Arg2) but you don't have any arguments to pass, right? I think...

Can you post all your code for both subroutines (it is best to use code tags, by the way)? Maybe that will help.

What do you mean by instance of a form? Do you mean calling it with a Dim frmName As NewForm statement prior to referencing it in code? I never do that but was taught it is the proper way. What is the purpose of doing that? I still don't quite understand why it is necessary. Anyway, if that...

Do you realize that you marked your thread "solved"? Anyway, yes you can call whatever subroutine you need (in the same class or in a public module) like this: Call Combobo_NotInList

When I started using code, I was mostly self-taught (with the help of Google). I would want to do something and search the web for a solution and use code other people posted. Once you get some basic familiarity with the event handlers and the concept of a module, it is not as intimidating...

Thank you, MarkK! Will try this tomorrow.

Ok, it turns out that the SearchFor seems to be working ok now. Sorry to have bothered...

It is most likely not the number of records (I am not dealing with huge datasets) but the number of tabs with subforms. Some of the read-only subforms have union queries as the recordsource. I am wondering if that is part of the problem. I will also try Shadow's solution of using lookups for...

I have a form that is opened as hidden when my startup form loads. Data gets entered into it from other forms so whenever I switch records the hidden form needs to be opened to the matching record. To accomplish this, I have been using the DoCmd.OpenForm in the OnCurrent event with the WHERE...

So long as you are not running MS Access 64bit I have had much luck with Allen Browne's concatenation function: http://allenbrowne.com/func-concat.html

SimonMT: I am not understanding your code. Perhaps this is too complicated for me. If I cannot figure out a way to only partially load a form, is there some way of letting users know that a form is loading? For some reason, the hourglass does not always show up during a form load...

SimonMT: In my previous post I was responding to the other respondent. I had not yet seen your solution. I will look it over. Thanks!

This isn't going to work for me because some of the controls on my main form depend upon the subform controls to get data. I need to keep it this way for reasons I will not go into. Is there some other way to improve the speed at which forms load? Thanks...

Simon_MT: this is a good solution without code. However, I do have one question: would keeping the main form in memory slow down other operations? I could definitely use this method but I want to make sure that performance won't be affected. Thanks!

I think I will try your solution but keep my subforms in their current tabs and just use the tab click event to set the recordsource for the subforms. Thanks for your idea.

or maybe there is a better way?

I want my tabs to stay as they are (so, keep each subform in its tab) but maybe not load any of the tabs except the main one unless the user clicks on it. So, rather than loading them all, load them one at a time. Is this possible? How do I use code to load the tabs?

Hello, All of my main forms contain multiple tabs and some of them take a long time to load. Would someone please explain the concept of lazy loading? Do you think it is a better way? Does it have its pitfalls? Some practical guidelines about how it is executed would also be much...