Filter a control on load

**nick.h** · 11-30-2011, 09:37 PM

I have an unbound combo box that pulls data from another field, and I would like to filter it so that some records do not show up for some users.

How would I write the code to filter the results?

**June7** · 12-01-2011, 02:46 AM

The records must have a field you can use to filter with, such as EnterBy field that has user ID. Then you need to get the user ID when they open the project. You can have them enter ID on a login form or grab the network username with: VBA.Environ("USERNAME"). Access will not recognize the Environ() function but VBA will.

Search this forum on keyword Environ and poster June7 to view other threads I have responded to on this topic. Here are two:
https://www.accessforums.net/securit...ers-17894.html
https://www.accessforums.net/access/...ser-18344.html

Filter a control on load

Thread Tools

Filter a control on load

Similar Threads

Filter data on a form from another control on the same form

filter the chart in one report by combo box control in one form

Use a control button + textfield(s) to filter for alternative value

filter records to populate form on load

Form - Filter on load (if data exists)

Posting Permissions