VBA code wont execute properly - kinda buggy

[jbone]

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

[CJ_London]

To make your code easier to debug, do the following:

1. Put Option Explicit at the top of the module, just below Option Compare Database
2. give all your controls and variables meaningful names
3. use indentation in your code so it is easier to read (certainly for people who are not familiar with your code)

[CJ_London]

addendum - consider using conditional formatting - you can't hide controls, but you can disable them. If the control is on a subform and the condition is based on a value on the main form, use the parent predicate to reference it e.g.

expression is....isnull(parent.controlname)

[jbone]

Thanks for your reply Ajax. I had figured something out by re-positioning the code