Web Database macro to open a form only if a condition applies

[gemadan96]

I'm working with the Contact Web Database. I've modified the NameCard form to add a type to the comments table when the save button is clicked. That works fine. The user is limited to four choices for the type (Call, E-mail, Text, and Visit).



What I'm trying to do now is that when Save is clicked if the Type (control named cmbCommType) equals Visit a form will open prompting the user for additional data regarding their travel.

If I just put an OpenForm command in the macro for the Save button it open with no problem. If I put in an If Action "If [cmbCommType]="Visit" Then, OpenForm..." it adds the comment but doesn't open the travel form.

Any suggestions to resolve this are appreciated.

[mildredrodriguez]

I want a msg box to appear if a date which falls on a Sunday. ... You can easily add conditions to your macros.

ONLINE CASINO AUSTRALIA