Combobox won't allow selection when form first opens

[Monterey_Manzer]

Hello Everyone,



I am having a little trouble with a fairly simple sort of dashboard form. Here is my situation:

I have a database which goes to a Splash Screen when opened and after 1.5 seconds closes that and opens my dashboard form. Rather than a series of buttons, this splash screen contains two combo boxes that I use to select the Form or Report that I want to navigate to. I then use a "Go!" button to execute the code that opens the selected Form or Report. The data source for each combo box is a values list.

The Problem: When the dashboard initially loads, after the splash screen closes, the combo boxes will not allow me to make a selection. Both of them, when clicked, show the appropriate values lists but nothing happens when I click on the form or report name that I wish to navigate to. When I enter Design view, or close and reopen the dashboard form, these combo boxes work just fine. I would like to apply this combo box navigation style to other databases that my coworkers use but I can't expect them to put up with the need to close and reopen the form each time. Does anyone know a way to solve this?

Thanks!

[June7]

Need to review code. If you want to provide db for analysis, follow instructions at bottom of my post.

[Monterey_Manzer]

Unfortunately there is too much confidential data present. Since I don't have much in the way of VBA in this database I'm guessing you would want to review the SQL. Is that correct? Perhaps if I knew more specifically what code you needed to review I could provide it.

[June7]

I expect code behind the splash screen and the dashboard forms as well as relevant queries. It would much easier to track down issue if could execute and debug code.

Don't care about data (although dummy records sometimes useful for testing). Make copy of db, remove data not relevant to the issue, etc.

[Missinglinq]

Since we're talking about a Splash Screen, here, and a Combobox that won't work, my guess would be that you've got the Form's AllowEdits Property set to 'No.'

Comboboxes will only function if AllowEdits is set to 'Yes.' The Access Gnomes apparently consider the use of a Combobox to be 'ediiting' the Form!

Linq ;0)>