If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

so you either use an unbound list box which when selected triggers a multi row form, or use a sub form to store details of each individual conversation/contact. the parent form contains data relevant to all conversations for that contact eg person, company and so on), the sub form contains details of who said what to whom and when

The list box is unbound. But what kind of VBA code will get the info from the listbox and textbox and write it to a table? Ive been researching makeing a UPDATE query in code but im still surfing for the answer to that.

OK so you need to coridnate the list box with the data
one way to do this is to apply a filter in the list boxes' on click event.
I can/t remember if by applyign a filter you automatically set the value, but if not then you need to set the callid to the value from the list box.

if you do go down this route you need to think through how you will add new rows to the call id.

the parent/sub form model would allow you to enter a callid/new head record and then automativcally pickup that value in the call details.