Hi All
Iam new to Access. I am using 2007 version. I have a form where user can choose option from radio buttons to search by address or property number or name.
If they choose search by address then I have 3 text box and a combo box to get input. e.g they would enter house number, the suffix and unit number and from combo box select the available street name. I have managed to populate my combo box with street names and bound the input boxes to the appropriate fields like house number text box to HOUSE_NO field from the table.
Now I cant make my search button/command to work when the user enters the address to search. I have provided appropriate text boxes in the form to display results for the particular property which is to be searched.
Please if someone can help. I am stressed out with this for 2 days now.
The tables I have is Address (Address_CTR as PK and PPROPERTY_CTR as FK), Property Table (PROPERTY_CTR as PK), Street Table (STREET_NO as PK and STREET_NAME as other field in the table), Name Table (NAME_CTR as PK), Association Table to eliminate the many to many relationship between name and property and address tables since one person can own many properties and one property can have many owners, and one person can have may address associations