Combo box is disabled after returning to previous form

[ScubaBart]

Ok, So I am finally back working on my Apiary / Honeybee Hive database after a long hiatus though have accomplished some improvements over time. But it still needs some development. Using a lot of the information this group previously provided has helped me simplify and expand on a lot of methods used to do what I want to do.



That being said, I have encountered a new problem that I simply cannot resolve. I have attached a current copy of my database file so hopefully someone can a determine what the problem is.

So, step by step, I open the main form F_Main_Overview.

I then select the <Edit/Add Hive Details> button. This brings up the "Active Hive Log", F_Log_Hive_Main form.

I then select the <Move Hive> button which closes the "Active Hive Log" screen and opens the "Move Hive" screen to provide the option to move a Hive from one Apiary to an alternate Apiary. The actual form name is F_Log_Hive_Status_Change as I use this base form for multiple purposes by simply changing various text fields and button actions.

I then return to the "Active Hive Log" and for some reason, the Combo Box at the top, "Filter List by Apiary" is no longer functional. It will show the drop down with the available options, but it does not accept making a selection.

Note that this condition occurs in more than one way. I can select a filter for a specific Apiary before selecting the <Move Hive> button and the filter value carries over to the "Move Hive" form. Returning to the "Active Hive Log" form keeps the filter condition but the Combo Box is then non-functional. I can change the Apiary filter selection to an alternate Apiary or to "All Hives" and return and again, the filter condition carries through but the Combo Box in non-funtctional.

I can open the "Move Hive" form with no filter applied, apply the Apairy Filter in that form, return to the "Active Hive Log" and the Combo Box is non-functional though again, the filtered condition remains (as it should).

From the "Active Hive Log" form, I can navigate to the "Add Hive" or "De-Activate Hive" forms and return and it's still non-functional.

The only way the function returns is by either returning to the Main Menu and coming back or by selecting the "List In-Active Hives" button and then coming back to the "Active Hives Log" screen.

I'm stumped.

Can anyone provide any insight as to what I am missing ?

[Micron]

I then select the <Move Hive> button which closes the "Active Hive Log" screen and opens the "Move Hive" screen

Not for me. Nothing opens at this point.
EDIT - looking at design, your move hive button has no event associated with it.

[jojowhite]

the problem is that when you return to F_Log_Hive_Main (re-open),
you open it with acFormReadOnly.
you remove this since on the Main (F_Main_Overview) you are not using acFormReadOnly.

i commented out on your code.

    If Forms!F_Log_Hive_Status_Change!Action_Mode = -1 Then  'Returns to Hive Log showing Active Apiaries
    
        DoCmd.Close acForm, "F_Log_Hive_Status_Change"
        DoCmd.OpenForm "F_Log_Hive_Main", acNormal, "", "Apiary_Active = -1"    ', acFormReadOnly
...
...
    Else  'Returns to Hive Log showing In-Active Apiaries
    
        DoCmd.Close acForm, "F_Log_Hive_Status_Change"
        DoCmd.OpenForm "F_Log_Hive_Main", acNormal, "", "Apiary_Active = 0 And Log_Hive_ID = 1" ', acFormReadOnly

[ScubaBart]

Not for me. Nothing opens at this point.
EDIT - looking at design, your move hive button has no event associated with it.

Not sure what happened as my copy has an event. May have become corrupted in the compression or decompression ?

jojowhite was able to open it and found the problem for me.

[ScubaBart]

the problem is that when you return to F_Log_Hive_Main (re-open),
you open it with acFormReadOnly.
you remove this since on the Main (F_Main_Overview) you are not using acFormReadOnly.

Many thanks !!!! I knew it had to be something simple.

[Micron]

Just to be sure about which button (and to show I'm not crazy - yet) we're talking about the move hive button?


EDIT - maybe I opened the wrong db seeing as how I still have your old one? Pretty sure I put the latest zip in it's own folder though, and opened that one. Maybe not. How to tell which is the latest one? Aside from the fact that info shows it as being created March 7?

[ScubaBart]

Just to be sure about which button (and to show I'm not crazy - yet) we're talking about the move hive button?


EDIT - maybe I opened the wrong db seeing as how I still have your old one? Pretty sure I put the latest zip in it's own folder though, and opened that one. Maybe not. How to tell which is the latest one? Aside from the fact that info shows it as being created March 7?

Yes, that button. Could very well have been an older one. The date of the zip file should indicate how current the database is but you make a valid point. I am going to start putting a date or release number on the main menu form and/or in the filename so if I have to upload again, it will be more obvious.

Had never given that any consideration before.

[Micron]

Good idea. Anyway, I figured it out. I unzipped the old file into a new folder. So yeah, I'm crazier than I thought.