Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


server filters and strange behavior

server filters and strange behavior

server filters and strange behavior

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.



RE: server filters and strange behavior

there isn't any way to edit a post, is there?  i misspoke in my first post.  the issue is not activating the server filter, the issue is with another section of code.  rather than continuing on in this thread, i'm just going to start a new thread.

RE: server filters and strange behavior

Are you using bound Fomr or Unbound form to add record?

RE: server filters and strange behavior

this particular issue was resolved.  however, in answer to your question, i'm using a bound form.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close