Automatically filling in info

[lscheer]

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.

 

[Neo90815]

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

access-programmers.co.uk

Good luck.