At 12:54 AM 2/11/2008, John Docherty wrote:
To answer your easy questions though, the column in question is a computed column, (on a computed column - perhaps not the most elegant solution) and I could change it using Data Designer to match the definition in another table, but the form isn't trying to change it at all it just links the two tables.
John, That is the exact reason of -ERROR- message. Technically, in your scenario, using DB Lookup ListBox, when assigning "List Source Key Field" value to a Data Field (computed column "de5" in Sched), you are updating the value when clicking on the list item. Hope that explains the reason of DB Lookup ListBox Error. You may look into Variable Lookup ListBox or Variable Lookup ListView to achieve you goal. Very Best R:egards, Razzak.
