b,
You should just use the AfterUpdate event of each of your Search Form's
"unbound" controls and just do: Forms![Results].Requery
Use\ing your Category# as an example. In the simplest sense, you can use
the AfterUpdate event and just do: Forms![Results].Requery.
The problem that I found was that Access created:
Private Sub Category__AfterUpdate()
and it doesn't fire.
You can't change it to:
Private Sub Category#_AfterUpdate() or
Private Sub [Category#]_AfterUpdate()
It's too late for me to deal with this. I don't use spaces or Special symbols
in my names, so I'd have to research this.
Your two form's look OK though. The Search query does its thing, but
you need some trick to fire the .ReQuery with those names.
Maybe someone else ...
Wayne
