View Full Version : filtering nightmare


arage
01-05-2001, 11:05 AM
Hi,
I have a big problem with my form.

Currently my form filters by region code & then by event #. I’ve allowed the find record option to remain active in case a data keyer needs to look at previous entries entered for the region.

Problem is that the form currently opens with ALL db entries entered & I need to find a way for data keyers to only see the entries against their region respectively.

I don’t know what I’m looking for. A filter? Vba code? what?

I’d appreciate any comments.
Thanks!

BarkerD
01-05-2001, 12:08 PM
Each data entry person has a specific region?

This sounds like something you can do by creating a mini lookup table with user names and region codes. on the load event of the form, check the value of CurrentUser(), and use DLookUp in the table to filter based on the region code.

Duane Barker