Command button

[Guest]

I wanted to create a command button that opens a 2nd form where the user can
input information that only pertains the 1st (main) form. Right now if I
enter information on the 2nd form, close it, go to 1st (main) form and to
another record and open the second form again it has the info I entered
ealier. The information on the second form is carying through on all my main
forms. Is there a way to do what I want?

 

[Jeff Boyce]

Michelle

From your description, it sounds like your "second form" is not bound to any
table or query. Thus, when you put a value in the form, it stays there.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Which reminds me that I've wondered, just where is that unbound data stored
anyway?

 

[Rick Brandt]

Which reminds me that I've wondered, just where is that unbound data
stored anyway?

It's not. If you are closing the second form and the data is still there
the next time you open it then the form and control ARE bound unless what
you are seeing is a default value. Most likely you are just opening to the
same record instead of filtering the second form to match the related record
on the first form.

What is the code used to open the second form?