Search for records problem

[Meads]

Hello I am wanting to make a search function so I can find a house
which shows the address and a subform with all the related tenants
below thus allowing me to insert more tenants as they arrive. I was
thinking of a combo box so I can see all the addresses then choose the
one I want. I tried this with the address and the house id in a combo
box then inserting the house id into the houseID field but it wouldn't
let me. Am I doing this right? Any recommendations for searching and
inserting in access? Any help we be much appreciated

thanks

 

[Bob]

Make sure that you use HouseID as the linking field
between the main and the subform. On the main form you can
add an unbound combobox to search for the address. Using
the wizard will step you through the process. Choose the
selection "Find a record in my form......"