i have an access 2003 adp pointing to a sql server 2000 db. i have a form that displays records using a view as the datasource. there is a "component" combobox that can be used to filter the records. the application includes a button (labeled "pass") that, if clicked, will set the value for a "status" combobox to a value of "pass" and will then navigate to the next record using docmd.gotorecord,, acnext.
when i first open the form, no server filter has been applied. if i click the "pass" button, things happen as expected. the current record's "status" combobox value changes to "pass" and the form navigates to the next record. however, if i use the filter combobox to apply a filter, suddenly the behavior of the "pass" button changes. now, when i click "pass", the current record's "status" combobox is not updated, though it still navigates to the next record. if i go back one record and click the "pass" button again, then it works as expected!?
behind the scenes, the oddity continues. if i step through the code, here's what happens. if server filter is applied, then the first time i click the "pass" button, when the code sets the "status" combobox's value to "pass", it triggers the forms "after update" event. when that happens, the combobox fails to change value. if i go back to the same record and execute the same code, the form's "after update" event does not fire.
any ideas on what is happening here? are there some special things about using server filters that i need to know about? any help much appreciated as i'm not sure what else i can do to solve this problem.
thanks,
glenn
when i first open the form, no server filter has been applied. if i click the "pass" button, things happen as expected. the current record's "status" combobox value changes to "pass" and the form navigates to the next record. however, if i use the filter combobox to apply a filter, suddenly the behavior of the "pass" button changes. now, when i click "pass", the current record's "status" combobox is not updated, though it still navigates to the next record. if i go back one record and click the "pass" button again, then it works as expected!?
behind the scenes, the oddity continues. if i step through the code, here's what happens. if server filter is applied, then the first time i click the "pass" button, when the code sets the "status" combobox's value to "pass", it triggers the forms "after update" event. when that happens, the combobox fails to change value. if i go back to the same record and execute the same code, the form's "after update" event does not fire.
any ideas on what is happening here? are there some special things about using server filters that i need to know about? any help much appreciated as i'm not sure what else i can do to solve this problem.
thanks,
glenn