Active Selection

[Dragon]

Hi,

I have a form showing order details. It has a 'Status' field. I would like
to provide a method for users to filter records displayed on this form based
on the status. Is there a way for me to provide drop-down list showing the
status codes and filter the records displayed immidiately as the status
selection changes? Also, how would I provide a "Display All" selection when
I don't even have a status code for it? Status codes are stored in a
seperate table.

Would it be better if I include check boxes instead and filter based on the
selected check boxes?

Thank you.

 

[MacDermott]

Look at FilterByForm in Access Help. It may not be exactly what you had
envisioned, but it's probably closer, for less work, than anything you might
build.

 

[Dragon]

Thank you. I will take a look at it.

Look at FilterByForm in Access Help. It may not be exactly what you had
envisioned, but it's probably closer, for less work, than anything you
might
build.