Opening a subform based on the criteria on the main form

[nyrob609]

Hi All,

I need some assistance I am trying to get a subform open when specific criteria has been enter in a field.

I have a field on the Main form that is drop down list for "Plan Name" I would like that when the user chooses "No Fault" and moves to the another field the subform pops up to enter additonal information that pertains to this case because No fault was choosen. I tried using a macro with the condition [AuthorizationTable]![Plan Name]="No Fault" open form didn't work.

I tried to do an event procedure on enter is not working.

Private Sub Plan_Name_Enter()
IIf ([Plan Name] = "No Fault")
DoCmd.OpenForm NoFaultWCompsubForm, acNormal, , , stLinkCriteria

Am I even on the right track...please any assitance will be greatly appreciated it.

Thank you

 

[pr2-eugin]

Why not try the After Update event of the Plan name? As this is executed everytime you update the value..