'#name?' with 2 tables and 1 form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have the following two tables;
1) Houses {HouseID(Primary Key),Address, Postcode, Landlord}
2) Landlords {Landlord(Primary Key), Address, Postcode}

I have a form where I am trying to display the HouseID, Address, Postcode
and then Landlords!Landlord, Landlords!Address, Landlords!Postcode. I can see
the first three fields but the last three fields give the '#name? error. Any
ideas?
 
I have created a relationship between Houses!Landlord and Landlords!Landlord
which should link the two tables togethor but I still cant see any fields
from the Landlords table.
 
Yeah,they are the same data type. I have a 'many-1 relationship' (i.e. a
landlord can have 1 or more houses).
 
Then what you want is a form for landlord with a subform for houses. You
can't handle it with just one form.

HTH;

Amy
 
Hi Amy,

My apologies in advance. I am very new to Access and VB. Can anyone point me
to a URL that details how to build a subform/form for the purposes of
updating two tables with one form?

Thanks,
--Paul
 
Back
Top