Using Access 2003 - I have a form with two list boxes. Both row sources for the list boxes are based on queries from the same table.
The rowsource query for List Box A has a criteria to include records only if a particular field's value is zero (lets call it Field1).
The rowsource query for List Box B has a criteria to include records only if Field1 has a value greater than zero.
If the user selects a line in List Box A and clicks a command button, that triggers off some code which puts a value in Field1 of the underlying table.
It is simple DAO code...
Rst.Edit
Rst!Field1 = [NewValue]
Rst.Update
... and the table does change appropriately
This should have the effect of moving the selected item from List Box A to List Box B when they are requeried.
So therefore I have followed the table update code with code that uses the requery command for the list boxes, namely:
Me.[List Box A].requery
Me.[List Box B].requery
But it doesn't work - the list boxes do not requery.
If F9 is pressed, they will requery but I don't want the user to have to remember to do this. I have tried using SendKeys "{F9}" after the requery commands above but that doesn't work.
I have tried putting DoEvents before and after the requery commands but that doesn't work.
These requery commands are also on the OnCurrent event. If you manually move to the previous or next record and return to the original, the list boxes requery. If I try to move to previous or next and then return to the original using code, once again it doesn't work.
I have used this double list box technique in earlier versions of Access and it worked OK.
Any help gratefully appreciated
Alan
The rowsource query for List Box A has a criteria to include records only if a particular field's value is zero (lets call it Field1).
The rowsource query for List Box B has a criteria to include records only if Field1 has a value greater than zero.
If the user selects a line in List Box A and clicks a command button, that triggers off some code which puts a value in Field1 of the underlying table.
It is simple DAO code...
Rst.Edit
Rst!Field1 = [NewValue]
Rst.Update
... and the table does change appropriately
This should have the effect of moving the selected item from List Box A to List Box B when they are requeried.
So therefore I have followed the table update code with code that uses the requery command for the list boxes, namely:
Me.[List Box A].requery
Me.[List Box B].requery
But it doesn't work - the list boxes do not requery.
If F9 is pressed, they will requery but I don't want the user to have to remember to do this. I have tried using SendKeys "{F9}" after the requery commands above but that doesn't work.
I have tried putting DoEvents before and after the requery commands but that doesn't work.
These requery commands are also on the OnCurrent event. If you manually move to the previous or next record and return to the original, the list boxes requery. If I try to move to previous or next and then return to the original using code, once again it doesn't work.
I have used this double list box technique in earlier versions of Access and it worked OK.
Any help gratefully appreciated
Alan
