Hi Guys,

I'm looking for a step by step tutorial exercise I can use to learn from, either from website or book which will show me unbound fields insertion into a listbox where the list box is a related table.

E.g. Call history with a customer. Entering the call details in an unbound controls and the results passed to the table which is queried for the list box and the list box requeried to update then the unbound controls cleared out.

Looked at WROX's solutions, as have them all for 2003, they come close however there's a step missing for it to sit in my head right. Hence this request, if admin will allow it.

Look up "cascading list box" or cascading combo boxes at Microsoft. There are some good articles there. What about this issue is not working for you? Usually this data is not comitted to the table until the record is saved, so done with variables and in memory, etc.

mmcdonal

Look it up at: http://wrox.books24x7.com

nope none of those have really helped.

Found a solution to half the problem, now its just the last bit.

e.g. select * from tblcalls where contactid = forms!frmcontacts!contactid is the source for the list box.

The fields of tblcalls are:

callid
contactid
calldate
calltime
callsubject
calldetails

and its call details that needs to go in an unbound textbox when you change entry in the list box

I also had a look at Dlookup as a recordsource with no joys on the net. I have seen this done so many times I just can't find the book its in.

disregard problem solved