Passing variable to a query

[Guest]

Hi
I have two forms, the first is a login form, usual username and password, I
want to remember the username and use it as a parameter in a query that loads
a list box in another form.

Unfortunately it fails, as the Login Form closes as the alternate form loads
so is unable to pass the username.

Can I populate the listbox in the alternate form On Load event-simple
question for you guys, but can't find an example (the search can either be
too vague or too specific).

Many thanks

Wendy

 

[Guest]

You can place it in a field on a hidden form. That way you can keep the
value on the hidden form all the time and have access to it whenever you want.

 

[Guest]

Create a Global variable in a Standard Form and put it there.

 

[Tim Ferguson]

Unfortunately it fails, as the Login Form closes as the alternate form
loads so is unable to pass the username.

Don't close the Login form, just make it invisible. If you opened it in
Dialog mode, then the code returns in the same way but you can still access
its properties and controls.

HTH


Tim F