Requery a dropdown field (1 Viewer)

Rushman21 · Apr 12, 2018

I have subform in a Main form that has Drop down field named Project Number and two Hours text fields Hrsworked and SPHrsworked. I have it set when you select a specific Project Number, one Hours field is active and the other not active. Example, select Project Number 1, you can add entries in Hrsworked but not in SPHrsworked. Select Project Number 2, Vise-versa. This is working fine.

But if I go back to edit the Hours, I can't input data in either of the Hours field until I re-select the Project Number. I tried a me.requery in both the main form and tried in the subform. But can't get it to work. I just need to know how to re-query (or refresh) the Project Number so I don't have to re-select it every time.

Thank you for your time.

Beetle · Apr 12, 2018

Try a requery of the Project Number combo box in the Current event of whichever form it is on.

Code:

Private Sub Form_Current()

    Me!cboProject.Requery

End Sub

moke123 · Apr 12, 2018

I often use the OnEnter event of the combobox.

Rushman21 · Apr 12, 2018

Thanks for the reply but that didn't work.

Beetle · Apr 12, 2018

Simply stating that it didn't work does not help get us any closer to a solution. What, exactly, did you try and what was the result (i.e. an error message, an undesired result, no result at all, etc.). You may also try posting a sanitized copy of your application so we can see the issue directly.

Rushman21 · Apr 12, 2018

Sorry about that. I put the code under the subform in the On Current. Me!Project_Number.requery. I have attached an example of what is happening. So, the Project Number that has 1501 or 1607, you should only be able to type in the TIBHrsWorked fields. But this is not the case until you create a new entry or if you re-enter an existing project number. Once you re-enter one project number, it all works like it should. But we don't want to have to re-enter every time we open the database. Hope this make's sense.

Beetle · Apr 12, 2018

OK, just call the Project Number After Update event in the Current event of the sub form;

Code:

Private Sub Form_Current()
    Project_Number_AfterUpdate
End Sub

Rushman21 · Apr 12, 2018

Perfect! That works. Thank you very much!

Requery a dropdown field (1 Viewer)

Rushman21

Registered User.

Beetle

Duly Registered Boozer

moke123

AWF VIP

Rushman21

Registered User.

Beetle

Duly Registered Boozer

Rushman21

Registered User.

Beetle

Duly Registered Boozer

Rushman21

Registered User.

Similar threads

Users who are viewing this thread