combo box problem

[Michael Nol]

Hi

I am having a problem with the coding for a combo box. I have a form called
frm_DFR which requires a client name and address saved to its underlying
table (tbl_DFR). I have made the client name a combo box so when I select
the client name the address is automatically filled in. The client names in
the combo box are stored in the client table but I require the to be saved
in tbl_DFR.

Can anyone help me with this

Thanks

Michael