I'm a newbie access programmer and I have a little problem. It must be easy

I have a form where the user must choose one option. Then that form closes and a new one is opened. How can I refer to the value of the first form's control from the second one????

I'm trying this:

Select * from table where table.name=[forms]![InitialForm]![Name]

Someone can help me???

Easy answer is to leave the first form open just set its visible property to false when opening the second and close it when the second closes.
Forms!YourFormName.Visible = False
HTH

Thanks HTH!

I know I shouldn't ask things like this in a forum (it's too simple), but I have to create a database really quickly and I have no idea of Access.

sigmar