Here's another one... I have a table with almost 600 dogs in total. I have a Status field and each dog has a status, eg. Breeding, Puppy, Sold, Retired, etc. The dogs I deal with on a day to day basis are mostly the Breeding dogs. I have quite a few forms where I have to pick a dog by its name from a combo box. The problem I have is, even if I type the name in, I sometimes end up with a few with the same name. Can I filter the combo box to only show me dogs with a specific status, like Breeding?
Adam Schwanz
@Reply 5 years ago
Sure you could use an after update event on your status field to change the row source of your dog name combo box. Add a where clause to it that filters it by the value in the status box.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Search Seminar.
