multi field combo boxes

[kpo]

Hello,

I have created a multi field combo box which is working perfectly but I am wondering if I can use what is chosen in the combo box as a new record. Is there a way to set the control source of this multi field combo box to match up to the same fields in another table?



When I put the 3 names of the fields into the control source I am getting "Invalid Control Proptery: Control Source; No such field in the field list."

By choosing just one of the 3 fields as the control source will it automatically match the combo box fields to the correct fields in the table?

THANKS IN ADVANCE!!

[June7]

Binding a combobox or listbox is the same as binding a textbox.

A ControlSource can be a field of the form or report RecordSource (a 'bound' box) or an expression (an 'unbound' box and result of expression will not be saved to table).

Selection in combobox will not create a new record in a table that is not included in the form RecordSource.