Hello

I have a main form 'frmFiche' with some subforms (notes, offers, contacts) that together give an overview of a prospect.
On the main form I have a combo box (cboZoekProspect) to search for a record of a prospect.

On the notes subform (sfrmNotitieLijst) I have a button to open a form (sfrmNotitieNieuw) so I can add a new note.
On sfrmNotitieNieuw I now have a combobox cboRelatie with the prospect names, cascading to a second combobox cboContact, allowing me to choose the contact person attached to the prospect.

What I would like to achieve is that the prospect name is already filled in in a textbox on the sfrmNotitieNieuw form and that the cboContact is populated with the contacts attached to the prospect. In short: replace cboRelatie with a text field but keep the cascading result in cbo Contact.

I managed to get the prospect name in a textbox on the sfrmNotitieNieuw form (=Forms![frm_fiche]!cboZoekProspect.Column (1)) but then I get no contacts in cboContact. Also after filling in the other fields on the form, the data is not saved in my table.

Any help is much appreciated.

Chris