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
clicks on the CandidateID a detail form opens (frmCandidateDetails).
frmCandidateDetails is based of the table CANDIDATES. The first tab is all
the detail info. The second tab contains a subform (frmJobDetails).
frmJobDetails is linked via CandidateID. When a user doubles clicks and
frmCandidateDetails opens, the user is able to see all the details and scroll
through all the related jobs on the second tab. The problem I am having is
that unless there is a related entry in the JobDetails, the
frmCandidatesDetails opens to a blank form. I can't figure out why. How can I
tell my macro to open the frmCandidatesDetails to the correct record even if
there the JobDetails is empty?

Thanks!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201004/1