Update form when data collected from Listbox

[Evetsllub]

Hi, I hope someone can help me with what i hope is a relatively simple question.

My coding etc skills are negative, i just find something on the interweb and try to make it fit, i have found something that almost lets me do what i want to do.

I have a form. There is a combobox where each person selects their name. This filters into a List Box (linked to a query) which shows all the work in their pipeline. Now what i want is for them to click on the field in the List Box they are working on and this will populate data into the rest of the form. Some of the data is to then be edited by the person working on the field.



This is all working, except it won't let me edit any of the fields in the form... its all to do with this expression I have in the fields, as it comes up with "Control can't be edited, its bound to the expression..."

Now the expression is this:

=IIf(IsNull(DLookUp("[Completed]","Work_Flow","[Plan Number]=" & [Forms]![Switchboard]!
[List61])),"",DLookUp("[Completed]","Work_Flow","[Plan Number]=" & [Forms]![Switchboard]!
[List61]))

where "completed" is the field to be edited, "Work_Flow" is the table the data sits in, "Plan Number" is the specific record number of the data being worked on, "List61" is the List Box that is feeding into this and "Switchboard" is the form.

I have also tried moving this expression to the "AfterUpdate" Event on the Listbox through VBA. This doesn't throw the error message, however anything i edit wont update the underlying table and when i click off & Back on it is back to what it was.

Can i amend this expression so that the data can be edited???

[llkhoutx]

You cannot reference a listbox row that way. You must use VBA to cycle through the listbox and determine which row, if any, is selected. Then in VBA calculate to desired value and store it on the form. It can then be updated, provided that your form recordset is updateable.