Here is my problem. I need to have users log in to the database on the opening form and use their log-in name to auto-fill other areas on other forms. The users will log-in by selecting their names from a Combobox.
What I want to do is create a Public Sub and in that Sub I want Public Variables that hold the Log-in (From the Login Combo login!loginCombo.text field) and also Public variables for Date and time. My big problem is I can not figure out how to make those variables work because youmust load Access 97 from a Form not a module and everytime I try to use the varaibles they do not work. I have considered Setfocus but do not understand it that well.
Can anyone get me on the right track here?
Oh, one more thing – I can not create a VB.exe, I must use just Access 97.
