Not finding other form

[bloody_football]

I would like to make a value equal to another value in another form, but it keeps telling me that it can't find the Form.

newID = Forms![frmLogIn]![UserID]

Error message is 'Access can't find the form 'frmLogIn' referred to in a macro expression or Visual Basic code'.

I have rechecked the spelling and caps on the form name 5 times so that's not it

James

 

[llkhoutx]

The message means that frmLogIn is probably not open.

 

[bloody_football]

Thanks for that; worked it out now

Another question - how do I keep the form open and behind everything? If someone closes another form then I want them to go back to the switchboard, not to the open form.

 

[JoeCruse]

How about having the 2nd form open, in hidden mode, when you open the other form? Upon closing your other form, programatically close the 2nd, hidden form.

 

[uncle-lai]

How about:

Declare a public variable in the Start module which stores the UserID when user logs in. Clear the variable when user logs out.

 

[bloody_football]

Thanks for both replies, will try them both and see what happens