Form/Subform link

[Guest]

I have two tables and relating forms. One holds information about camps and
the second holds data about each visit. I want to make the visit form a sub
form of the camps form. Each form is based on a tabe with campID field set
as the primary key. The two tables have a one to many relationship on the
CampID fields since you can visit each camp more than once.

I created the camps form with the visit sub form and linked the primary key
fields using the master/child settings.

The problem is that when I open a new record in the camps form, the campID
field on the sub form displays "CampsFrm", which is the main forms name. Why
does it not display the camp name which is the liked field? I do not want to
have to enter the campID manually each time.

If I open the visit form (view the form not as a subform), things display as
they should. Its only when its open as a subform that it displays something
unexpected.

I have created sub forms many times before and I have never seen this. I
have deleted the subform and recreated it in hopes that what ever setting I
have botched was reset, but it did not help.

Any suggestsions are appreciated,
Mike

 

[Guest]

Looks like I posted my question too soon. The name for my campID field on
the Camps form was "Name". This was a bad idea. I changed it to "CampName"
and everything works. Apparently Access uses "Name" internally.

Sorry for unecessarily adding to the site traffic...

 

[Douglas J. Steele]

For a good discussion of what names you should avoid using, check what Allen
Browne has at http://www.allenbrowne.com/AppIssueBadWord.html

 

[Guest]

Thanks for the link. It will be a big help!

Mike