Filter form on network ID

[AZHorseTrader]

Hello All:



I have a form I to filter on the user based on the user's network ID. I have a function in a module that determines the user's network ID (NetworkUserName). The employee table has a field (strNetworkID).

I want this trigger this subroutine when the form is loaded. Any thoughts on how this can be accomplished?

D

[RuralGuy]

Use the OnLoad event of the form to apply the Filter.

[AZHorseTrader]

Do you have an an example? I'm up against the clock and I'm not too familiar with applying filters using VBA.

Thanks much...

[RuralGuy]

How are you opening the form?