I have search the forum 1st it usually gives me the answer I need, but what I am trying to do it populate a combo box after I type in a text box.
What I want to do is Type in the the city and when I go to the combo box it only list the Units in that city.
I have a couple of table and I may have set That up wrong as Well.
tblMBRinfo has City and Unit in it with a lookup from tblUnits which has City and (PK) unit as well and I know this is replication so I am asking if there is a better way of doing this. I don't want Duplication in the combo box.
If the form is need to help I cam upload it.
Any help is greatly appreciated.
What I want to do is Type in the the city and when I go to the combo box it only list the Units in that city.
I have a couple of table and I may have set That up wrong as Well.
tblMBRinfo has City and Unit in it with a lookup from tblUnits which has City and (PK) unit as well and I know this is replication so I am asking if there is a better way of doing this. I don't want Duplication in the combo box.
If the form is need to help I cam upload it.
Any help is greatly appreciated.
