Search results

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...