I have two tables that I want to display info on one form. It would be awesome if I could select data from a combo box (from table 2) that would automatically fill in the rest of the fields' info from table 2. If I select someone's name, I want the remainder of their address fields to be filled in upon selection. If this is too tricky, I would like to open a pop-up or subform with the appropriate info (i.e. with the name fields in both forms matching) so the users can have a reference for the data.

Same question I had before. Check previous post for solution. It works for me.

access-programmers.co.uk (http://www.access-programmers.co.uk/ubb/Forum4/HTML/001002.html)

Good luck.