Reference to control LinkChild and LinkMaster

[silentwolf]

Hi guys,

Unfortunatelly I am stuck again..

I have a multipage contol in a access form... following tables I got..

tblKunden kunID Primary Key
tblObjekte objID Primary Key objKunIDRef ForeingKey to tblKunden
tblObjMitarbeiter objMID Primary Key objMObjIDRef foreignkey to tblObjekt

I have a code wich works fine and reference to the kunID but when I like to reference tblObjMitarbeiter to tblObject I can not make it work.


Here is the code I am useing...

    With Me.sfmDetails
        On Error Resume Next
        .SourceObject = ""
        .LinkChildFields = ""
        .LinkMasterFields = "kunID"
        On Error GoTo 0
        
        Select Case Me.mpgDaten.Value
        Case Me.pagKunden.PageIndex
           .SourceObject = "frmKundenDetails"
           .LinkChildFields = "kunID"
            
        Case Me.pagObjekte.PageIndex
            .SourceObject = "frmObjektKunden"
            .LinkChildFields = "objKunIDRef"
            
[COLOR=#ff0000]        Case Me.pagObjStunden.PageIndex
            .SourceObject = "frmObjMitarbeiter"
            .LinkMasterFields = "objID"
            .LinkChildFields = "objMObjIDRef"[/COLOR]

            
        Case Else

as the .LinkMasterField is not kunID I have troubles to reference it correctly..

In a multipage I got only one control ("Subform") which gets its values from the code above..
The code in red is not working and I am not quite sure how to reference it correctly..
I hope you guys understand what I am after and can help me with this.

Many thanks

 

[Micron]

I'll take a few guesses.
- You've wrapped all of this in a With block, so WITH an object (sfmDetails) on Me (the parent form) you are trying to set a property to an item that can't be found
- in the 3rd case, the reference is to a subform and the first two are not, which would mean your reference to the subform is incomplete
- in the 3rd case, the source object is not loaded
- there is a difference in spelling between your code and the actual name of an object

Do you get any error message? Have you tried stepping through the code and verified the existence and/or values of things upon the execution of each line of code?
Gotta say I'm not a fan of including a whole lot of stuff in a With block that doesn't apply to the object at hand.