I need a macro that does the following: if [attendee.vendor]=-1 then open form [vendorpre-reg] else exit macro
Thanks with any help. I am using access 2003. also have a computer with access 2010 if that will work better.
Thanks
I need a macro that does the following: if [attendee.vendor]=-1 then open form [vendorpre-reg] else exit macro
Thanks with any help. I am using access 2003. also have a computer with access 2010 if that will work better.
Thanks
Easier with VBA.
Is there really a period in your field name? I didn't think there could be, so perhaps that's table.field? Shouldn't need the table unless there are more than one in the form with the same field name. Symbols and spaces in your object names are not worth the bother in the long run.Code:If Me.[attendee.vendor]=-1 Then DoCmd.OpenForm "[vendorpre-reg]" End If