Results 1 to 7 of 7
  1. #1
    Lounger
    Join Date
    Oct 2001
    Location
    New York
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error Message in Subform (97 SR2)

    Under a couple of my subforms, I am receiving the message "The LinkMasterFields property setting has produced this error: 'Ambiguous names detected: Clients_Click'. What am I doing wrong? and how do I fix it?

  2. #2
    3 Star Lounger
    Join Date
    May 2002
    Location
    Toronto, Ontario, Canada
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error Message in Subform (97 SR2)

    Can you give a bit more detail than that?

    I know that the "Ambiguous Names" error arises when you've accidentally create and try to use two procedures with the same name...
    For example, if there are two sub procedures in the form module that are named "Client_Click" and the On Click event property is set to [Event Procedure], click that Client button and the error will come up...

    What that has to do with your subforms linked fields I have no idea? ...Have you actually checked that property (Link Master Fields) in the subforms to see what's there?

    HTH

  3. #3
    Lounger
    Join Date
    Oct 2001
    Location
    New York
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error Message in Subform (97 SR2)

    Let me explain what I am trying to accomplish, then maybe it will make sense. This DB is to track structured settlement cases. The Primary Key is the Index No for the matter. On my main form, I have all the basic information. Under the basic information are various tabs with additional information. One of those being Payee Information. Under Payee Information, I've created a sub-form of all the pertinent information. i.e., Payee name, address, etc. There can be more than one Payee, so I have it linked in a query to the MainInfo table linking the Index Nos. The same error message shows up under the Process Server Tab, where we can use more than one Process Server per Index No.

    I've check my On Click event, and I have no [Event Procedure] showing up...

    Thanks
    Nadia

  4. #4
    3 Star Lounger
    Join Date
    May 2002
    Location
    Toronto, Ontario, Canada
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error Message in Subform (97 SR2)

    Sorry... You misunderstood me... I didn't mean to check your On Click events...
    You had said that the error read: "The LinkMasterFields property setting has produced this error: 'Ambiguous names detected: Clients_Click'.

    First, I think you should check the form module for two procedures called "Client_Click" first.
    Second, you should check the subform control to see what shows in the Link Master Fields property...

    Hope that makes more sense... <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  5. #5
    Lounger
    Join Date
    Oct 2001
    Location
    New York
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error Message in Subform (97 SR2)

    Thanks for your last
    I took care of the ambigous "Clients_click"...that message has disappeared. My next problem is that now when I click on the command button to open the form with the Process Server information (address, etc), it's blank instead of showing the form with the information for that particular process server...Any suggestions? I recreated that command button but it just doesn't seem to work. I appreciate all your help.

    Thanks
    Nadia

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Error Message in Subform (97 SR2)

    Can you provide some information about the way you open the Process Server information form?
    - What is the code for the command button?
    - What is the record source of the form?
    - Does the form have code in its OnLoad or OnOpen event?

  7. #7
    Lounger
    Join Date
    Oct 2001
    Location
    New York
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error Message in Subform (97 SR2)

    Hans,

    Thanks for your questions, but as I continued to work in the database, I found my error, I was just linking the information to the wrong field within the table. When I had both tables linking to the ServiceID it worked fine.

    Thanks
    Nadia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •