View Single Post
  #2  
Old April 23rd, 2010, 08:42 PM posted to microsoft.public.access.gettingstarted
John W. Vinson
external usenet poster
 
Posts: 18,261
Default subforms and relationships getting #Name? error

On Fri, 23 Apr 2010 11:31:01 -0700, mholt261
wrote:

I am pretty new at access and need help! I have several forms that I need
linked together. When I put them all together using tabs I get the #Name?
error. I have checked the "record source" and it appears to be correct.
(Unless I am not understanding it correctly). I use the field "CID" as my id
number for the relationships. Any help would be greatly appreciated.


We cannot see your screen. You have not posted any information about your
table structures, what "CID" might be, or what you mean by "id number for the
relationships". Tabs are completely irrelevant; they just manage how controls
are laid out sharing screen space.

Your tables are fundamental. What are your Tables? What real-life Entity
(thing, person, event) does each table model? How are the tables related?

Forms are very distinctly secondary. There are no "relationships" between
forms - a Form will be linked to a Subform using master/child link fields, but
these will normally follow from the table relationships, not direct them.

More info please!
--

John W. Vinson [MVP]