Linking form to sub form in Office 2007

  • Thread starter Thread starter MARITA
  • Start date Start date
M

MARITA

--
I am creating a database in Access in Office 2007
There are 2 tables:
PersonTBL has 2 fields - Person, ID
ColorTBL has 2 fields - ID, color

I want to create a form where you select a Person and assign one or more
colors to that person - so it is a (simple) data entry form I am trying to
create.

the "ID" field is the primary key that links the two forms.
It should link automatically, but instead it insists the subform dislay the
ID field and I manually enter the ID into the field on the subform each time.
I want to enter an person ID on the main form and I want the subform to
simply show the Color field on the subform for me to type a color in.
I never had this problem in Access 2003.
 
Hi Marita,
In design view of the subform, on the data tab you can find the link master
and child fields.
Have you setup the link master fields and link child fields with ID?
(assuming ID is the name of the field that joins the 2 tables)

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Thanks Jeanette,
I came across the problem a couple of months ago and not re-visited it since
then. I jumped on the internet (to you) without testing it again...funny
enough it now works ok (It didnt work back then...honest... even out IT guy
at work was scratching his head and came up with a work around. The database
was created in Access 2003 and we were adding a new form to it using Access
2007, perhaps it didnt like that ). Anyhow, thanks for your quick reply! I
have looked at this site before for a couple of things and occasionally have
a look to see what things seem to be doing peoples heads in, and it has been
interesting and useful.
 
Back
Top