Populating Text boxes

Help needed, cannot sort this out :banghead:



So I have a very simple database I have two tables, table one (Master Info) holds a list of property addresses & information this is my master list containing all the property addresses I use. The second table (Property Info) contains various fields to store information that is entered in a form that i use to keep track of safety checks i,e date of next check, type of check etc



I am trying to do the following:



On the form (Property Info) I want a combo box populated from the (Master Info) table, that I do can fine but i want it to populate some text boxes with the other information from the Master table i,e post code, type of property. I then need to store that new selection into the table (Property Info)



I can create combo boxes with the wizard that find files based on what I select in the combo box but don't know how to save that forms info back to the (property Info) table



In summary, combo box from one table saved into a different table with additional fields through a form



Does this make sense to anyone?



Thanks for any help



Its driving me crazy

Populating Text boxes