Hi,
I have two tables Main and Survey, both of which contain a PtID. I have a form that has the Main table as the record source. However, there is one field,Facility, that is found in the Survey table that I would like to have auto populated based on the individual appearing in the form. The PtID is what connects these two tables I've tried to create an unbound combo box that connects the two tables by the PtID and adding that field with the associated Facility. All this does in the form is give me a list but does not give me a specific value.