Access 10 formatting questions

buzd said
#1 - I think you want to use the combobox's "After Update" event. Then grab your recordset and assign the form fields. (I'm speaking generically, because I usually use SQL pass-through which makes the data-access portion a little more difficult).

#2 - You can use code to write the address info to the address table, but it might be easier to just use a subform so you can save info by just using a "Refresh" action.

Thanks for the reply.

In the Properties of the combobox, I selected the Event tab. Correct? If so, is it a macro, expression or code builder? I am looking at the dropdown options in the macro, but I can't decipher what option it is.

I'm getting better by the day, but of course there is still much I don't know yet.