Switch between forms

[Dowsey1977]

Hi,

I have a form that records a load of people's person data, and a form that contains other information about that person.

What I want to be able to do is press a button when looking at the person data form and it brings up the other information form only showing the record for that person.

Any ideas?

 

[Corticus]

Make a button that will open the other form.

When clicked, this button will do the docmd.openform action. For the form that's opened, adjust the form's recordsource so it has the field in it by which it needs to be filtered (form properties|data|recordsource). Right click in the criteria for this field, select build, and 'browse' to the control from the originating form that contains the value by which you want the second form to be filtered. That should do it.

 

[Dowsey1977]

I want to be able to open the 2nd form normally as well as from the person data form, and view all the records. Will I need to have 2 copies of the same form?

 

[Corticus]

Then there's two options I know of.

1.
Make a copy of the second form. One copy will serve to access all records. The other copy is a 'review' form, that is filtered on the selection made in the first form.

2.
Set the recordsource of the second form programmaticaly. One cool way to do this is to something to the effect of:

Execute when the button to open the second form is clicked:

strSQL = form2.recordsource
form2.recordsource = replace(strSQL,";"," WHERE ID=" yourIDcontrol & ";")

Basically, just adding the WHERE condition to the end of the SQL that already exists for the form.

Actually, a third method would be to use the bookmark method, but I don't like that way. You can drop a combo on this second form and use the wizard (tell the wizard you want the form to go to the record selected in a control) to get your code.

I prefer two forms, usually the form to review the person specified in form1 is a little different than the form that allows for access to all records.

 

[Dowsey1977]

Perfect...thanks for your help!

ray: