Can a subform display the same as a mainform? (1 Viewer)

[paulmcdonnell]

Hi Guru's...

Ive got a main continuous form with a list of data subjected to two filters...I have an option which opens another form displaying only the relevant columns so it can fit everything on the screen.

I want the new form to adopt the same filters as were selected in the old form. How do I do this ...

Hope you can help

CHeers
Paul

 

[Liv Manto]

You could do it two ways, the rest of your data in a subform or in a pop-up form.

Yes you could use the same filter for the main and the second form.

Since you said that the main form has run out of spaces, subform is not the way to go.

Create a button that would open a form upon click. The second form should include the key record in your main form. Use the wizard, choose "Open a form based on criteria", equate the key record to the key record to modify the second form to be a pop-up form (Properties, Others)

 

[v.khawaja]

On the on load event of the “another form” put:

Private Sub Form_Load()
Me.Filter = Forms!”main continuous form”.Filter
If Forms!”main continuous form”.FilterOn = True Then
Me.FilterOn = True
End If
End Sub

Hope this gives you want you want.