If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Form opening to new record
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 |
#2
|
|||
|
|||
Form opening to new record
On Mon, 26 Apr 2010 17:49:07 GMT, "BenEl via AccessMonster.com" u56454@uwe
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 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! Correct the error in your doubleclick event. For help doing so please post the macro steps or the VBA code here. -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Form opening to new record
John W. Vinson 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 - 10 lines] Thanks! 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 |
#4
|
|||
|
|||
Form opening to new record
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 |
Thread Tools | |
Display Modes | |
|
|