Hide/Show Subform based on value in main form field

[iseman22]

Still trying to wrap my mind around the coding and was hoping you could help...

The parent form (Main) is tied to a table named Main; Subform is tied to a table named DODAAC. On the parent form are 4 fields I want to use to make the subform appear any time the user enters data which isn't in the DODAAC table.

I've tried various options. But, I think I'm so off-course; I don't want to include those options (code) here for fear it might give you the wrong idea of what I want.

This forum has so many helpful people--absolutely essential to access newbs like me. Thanks in advance, Paul.

 

[iseman22]

Sorry; forgot to add I'm using Access 2010.

 

[SueBK]

Oh, my goodness. Something I've actually done and might be able to help with; instead of always being on the receiving end.

The code I'm using for a similar situation is:

'After Update of checkbox check if checkbox is selected then show or hide subform
If Me.CheckBox = -1 Then
Me.Subform.Visible = False
Me.SubFormLabel.Visible = False
Else
Me.Subform.Visible = True
Me.SubFormLabel.Visible = True
End If

Not sure that will answer your entire problem, because I'm reading that you need "checkbox" (in my example), to actually check if it's the same value on the subform?

 

[iseman22]

Thanks for the reply Sue. Unfortunately, that code only works with a checkbox on the main form.

I need code to make my subform appear when a user enters a 6 digit code in a field on the main form that doesn't exist in an associated secondary table (tied to the subform--not the main).

I tried using

Private Sub DODAACCS_NotInList(NewData As String, Response As Integer)
Me.DODAAC_subform.Visible = True
End Sub

in the On Not in List event for the main form field with no luck. Not sure if it's important; but, I also have an On Change event for that field which populates two undound txt fields on the main form.

 

[rammudali]

hi,

it is not cleare that all the 4 field u r reffering is used making the subform visible or not. however, in the afterupdate event of the field, take the value into memory varial and use dlookup function to find the value in the DODAAC table. use if condition to make form visible if found else.

if you wish the method can be apply for all the 4 fields

enjoy

 

[iseman22]

Hi rammudali,

Good suggestion; but, I think I'm still missing something. Rather than using dlookup on the 4 control fields, I also have 4 unbound, lookup fields called City1, City 2, etc... Could I check to if they are blank with

Select Case
Case Me.City1 = Null
Me.DODAAC_subform.Visible = True
Case Me.City2 = Null
Me.DODAAC_subform.Visible = True
Case Me.City3 = Null
Me.DODAAC_subform.Visible = True
Case Me.City4 = Null
Me.DODAAC_subform.Visible = True
End Select

If true, set the subforms visible property to true. BTW, I tried the above in the after update event and got a syntax error. I know, probably a newb mistake.

Paul

 

[rammudali]

hi,

actualy I am not clear about your requirement. whether you want to check all 4 textboxes or either anyone them. I dont have any idea about structure and data of the of the table. however, i would suggest you to send the DB along with your clear requirement to suggest right a solution