Macro and Dlookup() help

[rkalapura]

Hai everybody,


I am a new user of Access2010. I have two problems and really appreciate if anybody help me to sort those out:
1. I have a conditional statement through a macro in the afterupdate event of a field in a form. I want to proceed to the next field only if the condition met (true) else need to exit without saving the record. What are the access 2010 macro command which I can use (a) to exit without saving the current record? (b) to go back to the first field in the form? I couldn't find anything in the list.

2. I use Dlookup() function to display values in my form. When I use Dlookup() with one criteria it works, but wont work with combined criteria.
Like Dlookup("[IRMaster]","[Kitmaster]","[KitID] = '"&[Forms]![Kitissue]![KitID]&"'") - This works.
Dlookup("[IRMaster]","[Kitmaster]","[BrgPN] = '"&[Forms]![Kitissue]![BrgPN]&"'") - This also works.
Dlookup("[IRMaster]","[Kitmaster]","[BrgPN] = '"&[Forms]![Kitissue]![BrgPN]&"'" and "[KitID] = '"&[Forms]![Kitissue]![KitID]&"'" ) This doesn't work. But record is available in the Kitmaster table to display with this combined criteria. Appreciate your help.

Thank you and best regards

[aytee111]

1. I don't know about macros, never use them - in VBA it is Cancel=True, maybe you can find a way to put that into a macro?

2 - remove quotes around "and" - it should be one statement : "this='A' and that='B'"
"[BrgPN] = '"&[Forms]![Kitissue]![BrgPN]&"' and [KitID] = '"&[Forms]![Kitissue]![KitID]&"'"

[rkalapura]

Thank you very much for your help. Dlookup() works fine. Didn't try the other. Will come back if solved.
Thank you once again. God Bless You