I'm missing th ISNull statement, but I'm not sure how to write it. Any ideas?



BenEl wrote:
Hi I am having a problem with my form not opening to the expected record. I
have a Summary form in datasheet view (frmCandidates). When the user double
[quoted text clipped - 4 lines]
Correct the error in your doubleclick event. For help doing so please post the
macro steps or the VBA code here.

Here is the macro:

OpenForm
frmCandidateDetails, Form, , ="[CandidateID]=" & Nz([CandidateID],0), ,
Normal
Requery

Thanks!

--
Message posted via http://www.accessmonster.com