Error Message in Subform (97 SR2)

Topic

New Reply

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?

Reply | Quote

Replies

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

Reply | Quote

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

Reply | Quote

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…

Reply | Quote

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

Reply | Quote

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?

Reply | Quote

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

Reply | Quote