I have a slight maybe not possible question. I have two list boxes, one of which is controled by a table anf filtered by a date the user selects, the other is values. The users can dblclick on the table controled list box and dump the values to the value controled list box and then saved to another table. When the users go back into the form, if they select the date again I have it filterning the data for values = to that date but not in the other table, that works.
Question is, how can I get a listbox with a value control to view table fields, allow the same interaction as a value list box.
LIST1
1)TABLE(Filtered By Date)
2)TABLE(Filtered by date and not = value
LIST2
1)VALUES dumped from LIST1
2)Need it to be values in table, with the ability to add from list one (without insert) I need the user to issue my save.
Question is, how can I get a listbox with a value control to view table fields, allow the same interaction as a value list box.
LIST1
1)TABLE(Filtered By Date)
2)TABLE(Filtered by date and not = value
LIST2
1)VALUES dumped from LIST1
2)Need it to be values in table, with the ability to add from list one (without insert) I need the user to issue my save.
