does it matter if the source type is listed as a value list? Should I change it?
([Forms]![Comp Request Form]![Type of Comp].[Column](1)=[Business]) And ([Forms]![Comp Request Form]![Patron Number] Is Null)
is coming up with a dialogue box that says:
"Microsoft Access can't find the name...
I just did, and retested it, and it still says type mismatch:
([Forms]![Comp Request Form]![Type of Comp].[Column](1)="Business") And ([Forms]![Comp Request Form]![Patron Number] Is Null)
Hi Cookiegary,
Thanks for your response - You are right that [type of comp] is a dropdown menu.
I tried copying that directly into the conditions column, but I had made a mistake in the name of the title, here's what it got changed to:
([Forms]![Comp Request Form]![Type of...
Hello Forumers,
I've been trying to teach myself Access 2007 for a little while, and I come to you now seeking guidance on a problem I've been having.
I need to create a macro which validates a rule when the user goes to save the form. I'm trying to get it to say that if the request is for a...