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 10 months 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.