Hi,
I'm still stuck & getting frustrated despite the efforts of the forum. To reiterate, I have a tabbed main form 'Main_Form' into which I have 4 tabs. one of which is 'Calibration' onto which I've copied 'FRM_Equipment'. I use several of the fields from this form to generate the title for the Activity. I use several of the fields from 'FRM_Inspect_Record subform' a subform on 'FRM_Equipment' to generate values for the repeat date etc which becomes the outlook task. No matter how I try, i cannot seem to get the referencing right. It all worked till I decided to move 'FRM_Equipment' to a tabbed main form. Upon disabling error routines, it errors out after update of text37, where it calls routine 'ValidateFields' and crashes @;
If Forms![Main_Form]![FRM_Equipment]!Form![Equipment_Desc] = Empty Or IsNull(Forms![Main_Form]![FRM_Equipment]!Form![Equipment_Desc]) Or Len(Forms![Main_Form]![FRM_Equipment]!Form![Equipment_Desc]) = 0 Then
s = s & vbNewLine & "'Subject'"
If I comment out this routine, the subroutine returns, only to crash at the next subroutine "CreateTask" with the following;
Temp_Site = DLookup("[Site_Name]", "TBL_Site", "[SiteID] =" & Forms![Main_Form]![FRM_Equipment].Form![SiteID])
Clearly, I haven't gotten the referencing right, no matter what I try. I's probably a 2min fix, but driving me mad, leave alone the other tweaks I've been advised to do.
I really need to finish this project. I would be eternally grateful for any assistance the forum could provide.