Solved

SubForm Problem

Posted on 1998-06-05
1
204 Views
Last Modified: 2008-03-06
Using Access 97, I have created a main form using tab control pages. There are three underlying tables all based on the one primary key. I am attempting to insert two subforms into two different tab control pages. The problem is when I try to enter records, I receive this message "The LinkMasterFields property setting has produced this error: 'Ambiguous name detected: Last_record_click'". I get the same message if I try to use command buttons in the tab control page. What does this message mean given that the relationships between my tables could not be simpler?
0
Comment
Question by:djadams
1 Comment
 
LVL 17

Accepted Solution

by:
ramrom earned 100 total points
ID: 1974917
'Ambiguous name detected' has nothing to do with tables or relationships. Go to Help, Find, Ambiguous name detected, and read the reasons (TMWWTP) for the error. Look in your modules for two or more occurances of 'Last_record_click' (I'm assuming it is the name of a Sub.

*TMWWTP = that Microsoft was willing to publish, since they often omit vital information from their documentation.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now