Combo box issue (sorry newbish)

[vicsalt]

I have created a drop down box for my customer field the combo box has multiple collums. I have a second field which fills in the address dependant on the customer selected using the following

=[Cust_cmbo].[Column](1)

This workes fine the address field fills with the correct data .

Here is my question

How do I assosiated the address field to the address field in the related table on saving the record?

 

[Galaxiom]

Use VBA to write the address textbox to the address field in the recordset of the form.

Usually triggered in the Before Update event of the form.

Me!fieldname = Me.textboxname

BTW It is a very common misunderstanding but those objects such as textboxes on forms are called "Controls". The "Fields" on a form are in its recordset and despite (unfortunately) often having the same name due to the Access Wizard they are very different.

 

[vicsalt]

Use VBA to write the address textbox to the address field in the recordset of the form.

Usually triggered in the Before Update event of the form.

Me!fieldname = Me.textboxname

BTW It is a very common misunderstanding but those objects such as textboxes on forms are called "Controls". The "Fields" on a form are in its recordset and despite (unfortunately) often having the same name due to the Access Wizard they are very different.

Sorry not familure with VB at all, I have dragged the adress field onto my form and the control field is then assosiated with the correct field in the table then on the default value in the property box set to =[Cust_cmbo].[Column](1) but this doesnt work either, any other solutions

Thanks

 

[Galaxiom]

Sorry, there is no alternative to using VBA. Time to get familiar with it.