Public Variables, OpenArgs and Compatability issues (1 Viewer)

[tempk]

Hi all,
I seem to have encountered a strange problem at work.

I declared a public variable for user department. The user selects his department from a Log On form and if the password is correct, he opens another form with the department variable passed on in openargs.

All of this works fine in access2k but upon testing with 2003, the openargs somehow do not seem to be being passed on. Maybe I am being dense somewhere but it is kinda puzzling for me.

I am not using access's security for users and groups because I am trying to reduce the complexity of the whole project (I wont be around to maintain it next time).

Any help rendered is greatly appreciated!

 

[SunWuKung]

This won't be a high level answer but here is what I usually do:
I usually store the selection of the user in a table - UserID, ObjecType, ObjectID. This way you can have user preferences stored and so on. When I am too lazy to do this I store user selections on the central switchboard form in a non-visible text field. I try to avoid using public variables for this as I often ran into similar problems.
hth
SWK

 

[tempk]

Hey, thanks for the reply. Good to know what others are doing to circumvent the problem!