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.
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.