filter in form

[Guest]

Hi,

I have a table with fields: RecordID, Part#, ProductLine, Tester, Status, ...
The field status is value list: TBD, Pass, Fail, Not Analyzed.
This is a big table, with a lot of record. I created a form for the tester
to update the status. For example updtae the status: TBD to Pass or Fail.
I want to narrow the the record by the tester, so the tester can update
their data easyly.

Can I use filter by Tester in the form, but my form is display as a tabular
format.
How can I create a combox to filter the records, where I should place the
combox?

Please help, and thanks advance.

 

[Allen Browne]

Place the unbound combo in the Form Header section.
(View menu if you don't see this in design view.)

This combo's Row Source Type will be Value List also, and it will contain
the same Row Source.

Use the AfterUpdate event procedure of the combo to set the Filter of the
form (remembering to set FilterOn as well.)