Hello, I made a form that is controlled by a table called "HICFA". On this form, I have a combo box that is controlled by another table called "Hospitals". I have successfully setup the combo box to list the names of the hospitals from the "Hospitals" table. My problem is I need the Name of the hospital that is selected on the form, plus the full mailing address to display on my report (which is controlled by table - HICFA). How do I accomplish this? I have created an example database showing exactly what I'm trying to do if someone would take a look at it for me I would greatly appreciate it! :)

Thanks,
Eric

I changed your combo box name and text box names to remove spaces (you want to avoid embedded spaces in your object, and field, names as it will make your life much easier.

Also, I added the appropriate fields to the combo rowsource and then in the After Update event updated the text boxes accordingly.

Check out the revised sample.