I want to have a form that, from a combo box, I can select the name of an apartment complex and the rest of the address is looked up and filled in to the table so I can use that address in other forms. So far I have 2 tables. One with personal information and the other with addresses. I have done it before but now I am stuck.

Please help

Do you want to look up the address in the table and have it show in the form?

I think the easiest solution, though there are others, is to make your combo box multicolumn, include the address field in the rest of it (you can make those columns hidden), and then in the AfterUpdate:
[UnboundAddressField]=Me.Combo(x)
etc. Remember that combos start at 0, not 1, and your visible column is likely to be #1.

HTH,
David R