Hello Everyone,
it is never easy to explain these situations but I am going to do my best.
I have a situation where I want to update records in a table via a form. The form I created is query based and so it finds me the records based on the criteria [which is,in my case, Text15 Value]. This query form is in a main form- so essentially is a subform and I toggle between forms using a side bar I created. I use the 'make visible' code to bring up the form.
When I run the query by searching a in the text field [text 15 - criteria] it brings up records (highlighted in yellow in the picture).
if 'Number of inadequate responses' field is blank as well as 'Resolution Date' field I want to make the below (circled in black in the picture) visible so the user can Update their record BUT if it is not blank (say they re-search their Case Number again) I want it to not be visible - so they cant override their initial submission.
Just to add some context to the Submit Button will update the record in the table (field inadequate responses' & 'Resolution Date') and make the below (circled in black in the picture) not visible as well. I dont know how to refresh the whole subform to start over again - Ive tried a million things.
Here is my code for the if statement
If IsNull(Me.number_of_inadequate_response.Value) Then
Me.Combo30.Visible = True
Me.Text21.Visible = True
Me.Text23.Visible = True
Else
Me.Combo30.Visible = False
Me.Text21.Visible = False
Me.Text23.Visible = False
Me.Combo30.Value = ""
Me.Text23.Value = ""
Me.Text21.Value = ""
End If